transformations:splitfixedwidthtext
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revisionNext revision | |||
— | transformations:splitfixedwidthtext [2021/04/21 08:10] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | {{ transformations: | ||
+ | ======SPLIT FIXED WIDTH TEXT====== | ||
+ | Category: Transform / Advanced \\ | ||
+ | \\ | ||
+ | =====Description===== | ||
+ | This action splits text values of the selected column into multiple columns of values of specified lengths. It is similar to the [[transformations: | ||
+ | |||
+ | **Show preview: | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Use this action when you have a column of text-based data in which the fields are defined by //spacing// (spaces, tabs, leaders, etc.) rather than delimiting characters and you need to separate them into columns.\\ | ||
+ | \\ | ||
+ | If your data has // | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Column|Select the column with values to split.| | ||
+ | |Column|Select the column containing the text to be split.| | ||
+ | |Decimal|Select the character to represent the decimal point for columns determined to be containing numeric values, after splitting. | ||
+ | |Keep original column|When selected, the source column will remain in the dataset.| | ||
+ | |New columns|Refer to the table below for //new column// settings.| | ||
+ | |Put remaining symbols into column|Check " | ||
+ | \\ | ||
+ | ====New columns settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Add more columns|This button will open a list where the columns in the imported file can be explicitly defined by Name and Width.\\ | ||
+ | |Name|The names to be assigned to the new columns.| | ||
+ | |Width|The size, in characters, of the column. | ||
+ | |||
+ | {{transformations: | ||
+ | |||
+ | =====Remarks===== | ||
+ | Leading and trailing whitespace is automatically removed from values when the new columns are created.\\ | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | \\ | ||
+ | **Source dataset:** | ||
+ | ^ Timestamp ^ | ||
+ | | 20170102T08: | ||
+ | | 20170103T08: | ||
+ | | 20170104T08: | ||
+ | \\ | ||
+ | **Action settings:** | ||
+ | > Column settings: | ||
+ | > Column 1 Name is " | ||
+ | > Column 2 Name is " | ||
+ | > Column 3 Name is " | ||
+ | > Column 4 Name is " | ||
+ | > Column 5 Name is " | ||
+ | > Column 6 Name is " | ||
+ | > Put remaining symbols into column " | ||
+ | |||
+ | \\ | ||
+ | **Result:** | ||
+ | ^ 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| | ||
+ | Use the [[transformations: | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | |||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: |
transformations/splitfixedwidthtext.txt · Last modified: 2021/08/14 21:47 by craigt