User Tools

Site Tools


transformations:splitdelimitedtext

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
2017May 12
2018Sep 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: 2018/01/25 02:47 by dmitry