User Tools

Site Tools


transformations:splitfixedwidthtext

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:splitfixedwidthtext [2018/07/22 20:16] (current)
dmitry created
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: 2018/07/22 20:16 by dmitry