User Tools

Site Tools


transformations:subfield

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
1one;two;three

Delimiter: Semicolon

Row no Numbers
1one
1two
1three

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.txt · Last modified: 2018/07/04 00:49 by dmitry