transformations:splitfixedwidthtext
This is an old revision of the document!
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 |
|---|---|---|---|---|---|---|
| 2017 | 01 | 02 | T | 08 | : | 31 |
| 2017 | 01 | 03 | T | 08 | : | 22 |
| 2017 | 01 | 04 | T | 08 | : | 15 |
transformations/splitfixedwidthtext.1532290572.txt.gz · Last modified: 2018/07/22 16:16 by dmitry