EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » subfield
transformations:subfield

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
transformations:subfield [2021/04/20 13:43] – craigttransformations:subfield [2021/07/18 23:28] – craigt
Line 5: Line 5:
 \\  \\ 
 =====Description===== =====Description=====
-This action splits column values delimited with a separator (e.g. comma) into multiple rows -- one row per value. Values in other columns are duplicated in the new rows.\\+This action splits column values delimited with a separator (e.g. comma) into multiple rows -- one row per value. 
 + 
 +Values in other columns are duplicated in the new rows.\\
  
 \\ \\
Line 21: Line 23:
 =====Remarks===== =====Remarks=====
 Unlike the [[transformations:splitdelimitedtext|Split delimited text into columns]] action, in which you have to define the new columns to receive the split values, this action will create as many new rows as necessary to output all split values in the selected column. Unlike the [[transformations:splitdelimitedtext|Split delimited text into columns]] action, in which you have to define the new columns to receive the split values, this action will create as many new rows as necessary to output all split values in the selected column.
 +
 +Leading and trailing whitespace are automatically removed from values when the new columns are created.\\
  
 \\  \\ 
Line 35: Line 39:
 > Delimiter: Semicolon > Delimiter: Semicolon
 \\  \\ 
-**Result:**+**Result table:**
 ^ Row no ^ Numbers ^ ^ Row no ^ Numbers ^
 | 1|one   | | 1|one   |
Line 41: Line 45:
 | 1|three | | 1|three |
  
-\\   \\ +\\ \\ 
 **Example 2:** A column with multi-line text values.\\ **Example 2:** A column with multi-line text values.\\
  
Line 53: Line 57:
 > Delimiter: Line break > Delimiter: Line break
 \\  \\ 
-**Result:**+**Result table:**
 ^ Location No ^ Location ^ ^ Location No ^ Location ^
 | 1| Mississauga    | | 1| Mississauga    |
Line 77: Line 81:
 > Separator: Comma > Separator: Comma
 \\  \\ 
-**Result:**+**Result table:**
 ^Customer ID^Order IDs^ ^Customer ID^Order IDs^
 |CUST001  |ORD001  | |CUST001  |ORD001  |
Line 89: Line 93:
 |CUST003  |ORD007  | |CUST003  |ORD007  |
 |CUST003  |ORD008  | |CUST003  |ORD008  |
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1268/4|Parsing JSON/XML from web responses]] ([[https://community.easymorph.com/uploads/short-url/6ftyNHFkbIwRqPFtqQtKHHBu3jl.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1332/3|String manipulation (REVERSE)]] ([[https://community.easymorph.com/uploads/short-url/67c52KIJt323kknw2Q4vOvlAJ05.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Using actions//; Action position: //3//)
 +  * [[https://community.easymorph.com/t//1803/3|Create dynamic list from delimited text (dynamic split/dynamic generate list)]] ([[https://community.easymorph.com/uploads/short-url/vd59gCPQiP8m4hiFPZmYiRDKW31.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Output//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//1882/3|Transforming Single Row of Data from CSV into Multiple Rows]] ([[https://community.easymorph.com/uploads/short-url/mEw4PYroNSO8QmJx0ykBvIuP6Ns.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//)
  
 \\  \\ 
transformations/subfield.txt · Last modified: 2023/10/11 20:54 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki