User Tools

Site Tools


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/21 15:35] – [Remarks] craigttransformations:subfield [2023/10/11 20:54] (current) – [Remarks] craigt
Line 25: Line 25:
  
 Leading and trailing whitespace are automatically removed from values when the new columns are created.\\ 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 39: Line 41:
 > Delimiter: Semicolon > Delimiter: Semicolon
 \\  \\ 
-**Result:**+**Result table:**
 ^ Row no ^ Numbers ^ ^ Row no ^ Numbers ^
 | 1|one   | | 1|one   |
Line 45: 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 57: Line 59:
 > Delimiter: Line break > Delimiter: Line break
 \\  \\ 
-**Result:**+**Result table:**
 ^ Location No ^ Location ^ ^ Location No ^ Location ^
 | 1| Mississauga    | | 1| Mississauga    |
Line 81: Line 83:
 > Separator: Comma > Separator: Comma
 \\  \\ 
-**Result:**+**Result table:**
 ^Customer ID^Order IDs^ ^Customer ID^Order IDs^
 |CUST001  |ORD001  | |CUST001  |ORD001  |
Line 93: 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