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
transformations:subfield [2021/04/20 13:43] – craigttransformations:subfield [2023/10/11 20:54] (current) – [Remarks] 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.\\
 +
 +**Import 2 to 3 times faster (experimental feature).**  This feature affects the "Split delimited text..." actions as well. To enable this feature, check //on// the "Twice faster CSV import" option in Application Settings (in the About toolbar).
  
 \\  \\ 
Line 35: Line 41:
 > Delimiter: Semicolon > Delimiter: Semicolon
 \\  \\ 
-**Result:**+**Result table:**
 ^ Row no ^ Numbers ^ ^ Row no ^ Numbers ^
 | 1|one   | | 1|one   |
Line 41: Line 47:
 | 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 59:
 > Delimiter: Line break > Delimiter: Line break
 \\  \\ 
-**Result:**+**Result table:**
 ^ Location No ^ Location ^ ^ Location No ^ Location ^
 | 1| Mississauga    | | 1| Mississauga    |
Line 77: Line 83:
 > Separator: Comma > Separator: Comma
 \\  \\ 
-**Result:**+**Result table:**
 ^Customer ID^Order IDs^ ^Customer ID^Order IDs^
 |CUST001  |ORD001  | |CUST001  |ORD001  |
Line 89: Line 95:
 |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