User Tools

Site Tools


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
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.1530665385.txt.gz · Last modified: 2018/07/03 20:49 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki