transformations:subfield
This is an old revision of the document!
Split delimited text into rows
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 value with 3 words delimited with semicolons will be split into three rows:
| Row no | Numbers |
|---|---|
| 1 | one;two;three |
Delimiter: Semicolon
| Row no | Numbers |
|---|---|
| 1 | one |
| 1 | two |
| 1 | three |
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/subfield.1530665385.txt.gz · Last modified: by dmitry