User Tools

Site Tools


transformations:splitfixedwidthtext

Split fixed width text

This action splits text values of selected column into multiple columns of values of specified length. It is similar to the "Import fixed width text" action with the difference that it works with already loaded dataset.

Example

Source dataset:

Timestamp
20170102T08:31
20170103T08:22
20170104T08:15

Objective: extract year, month, day, hour and minute from the timestamps.

Settings: Year (4 characters), Month (2 characters), Day (3), Separator1 (1), Hours (2), Separator2 (1), Minutes (remaining characters).

Result dataset:

Year Month Day Separator1 Hour Separator2 Minutes
201701 02 T 08 : 31
201701 03 T 08 : 22
201701 04 T 08 : 15
transformations/splitfixedwidthtext.txt · Last modified: 2018/07/22 20:16 by dmitry