Differences

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

--- transformations:subfield [2016/06/19 19:38] – created dmitry
+++ transformations:subfield [2018/07/03 20:49] – dmitry
@@ Line 1: / Line 1: @@
-===== Split column into rows =====
+===== Split delimited text into rows =====
-Split column values delimited with a separator (e.g. comma) into multiple rows -- one row per value.
+Split column values delimited with a separator (e.g. comma) into multiple rows -- one row per value. Values in other columns are duplicates for the new rows.
-For instance, a column value
+For instance, a value with 3 words delimited with semicolons will be split into three rows:
-  one;two;three
+^Row no ^Numbers ^
+| 1|one;two;three |
-will be split into three rows
-  one
+Delimiter: Semicolon
-  two
-  three
+^ Row no ^ Numbers ^
+| 1|one   |
+| 1|two   |
+| 1|three |
-Values in other columns are duplicates for the new rows.
+Another example:
+A column with multi-line text values.
+^ Location No ^ Location ^
+| 1| Mississauga \\ Ontario \\ Canada \\ North America |
+| 2| Cambridge \\ Massachusetts \\ United States \\ North America |
+Delimiter: Line break
+^ Location No ^ Location ^
+| 1| Mississauga    |
+| 1| Ontario        |
+| 1| Canada         |
+| 1| North America  |
+| 2| Cambridge      |
+| 2| Massachusetts  |
+| 2| United States  |
+| 2| North America  |
+===See also===
+  * [[transformations:splitdelimitedtext|Split delimited text into columns]]
+  * [[transformations:splitfixedwidthtext|Split fixed width text into columns]]