transformations:splitdelimitedtext
This is an old revision of the document!
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/Province | Country | Continent |
|---|---|---|---|
| Mississauga | Ontario | Canada | North America |
| Cambridge | Massachusetts | United States | North America |
transformations/splitdelimitedtext.1516848460.txt.gz · Last modified: 2018/01/24 21:47 by dmitry