transformations:splitdelimitedtext
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:splitdelimitedtext [2018/01/24 21:47] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Split delimited text into columns ===== | ||
+ | This transformation allows splitting text values that are delimited text into multiple columns. For instance: | ||
+ | |||
+ | ^ Date ^ | ||
+ | | 2017-May-12| | ||
+ | | 2018-Sep-30| | ||
+ | |||
+ | Delimiter: - (dash) | ||
+ | |||
+ | Result: | ||
+ | ^ Year ^ Month ^ Day ^ | ||
+ | | 2017|May | 12| | ||
+ | | 2018|Sep | 30| | ||
+ | |||
+ | Another example: a column with multi-line text values. | ||
+ | |||
+ | ^ Location ^ | ||
+ | | Mississauga \\ Ontario \\ Canada \\ North America | | ||
+ | | Cambridge \\ Massachusetts \\ United States \\ North America | | ||
+ | |||
+ | |||
+ | Delimiter: Line break | ||
+ | |||
+ | ^ City/town ^ State/ | ||
+ | | Mississauga | Ontario | ||
+ | | Cambridge |
transformations/splitdelimitedtext.txt · Last modified: 2023/10/11 20:53 by craigt