User Tools

Site Tools


transformations:splitdelimitedtext

Differences

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

Link to this comparison view

transformations:splitdelimitedtext [2018/01/25 02:47] (current)
dmitry created
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/​Province ^ Country ^ Continent ^
 +| Mississauga | Ontario ​       | Canada ​        | North America ​ |
 +| Cambridge ​  | Massachusetts ​ | United States ​ | North America ​ |
transformations/splitdelimitedtext.txt · Last modified: 2018/01/25 02:47 by dmitry