User Tools

Site Tools


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/Province ^ Country ^ Continent ^
 +| Mississauga | Ontario        | Canada         | North America  |
 +| Cambridge   | Massachusetts  | United States  | North America  |
transformations/splitdelimitedtext.txt · Last modified: 2023/10/11 20:53 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki