transformations:splitfixedwidthtext
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:splitfixedwidthtext [2018/07/22 16:16] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== 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 [[transformations: | ||
+ | |||
+ | **Example** | ||
+ | |||
+ | Source dataset: | ||
+ | ^ Timestamp ^ | ||
+ | | 20170102T08: | ||
+ | | 20170103T08: | ||
+ | | 20170104T08: | ||
+ | |||
+ | Objective: extract year, month, day, hour and minute from the timestamps. | ||
+ | |||
+ | Settings: Year (4 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.txt · Last modified: 2021/08/14 21:47 by craigt