User Tools

Site Tools


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:importfixedwidthtext|"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.txt · Last modified: 2021/08/14 21:47 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki