transformations:splitfixedwidthtext
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:splitfixedwidthtext [2021/04/21 08:10] – craigt | transformations:splitfixedwidthtext [2021/07/19 02:17] – [Examples] craigt | ||
---|---|---|---|
Line 7: | Line 7: | ||
This action splits text values of the selected column into multiple columns of values of specified lengths. It is similar to the [[transformations: | 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: | + | **Show preview: |
\\ | \\ | ||
=====Use cases===== | =====Use cases===== | ||
- | Use this action when you have a column of text-based data in which the fields | + | Use this action when you have a column of text-based data in which the individual values |
\\ | \\ | ||
If your data has // | If your data has // | ||
Line 18: | Line 18: | ||
=====Action settings===== | =====Action settings===== | ||
^Setting^Description^ | ^Setting^Description^ | ||
- | |Column|Select the column with values to split.| | ||
|Column|Select the column containing the text to be 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. | |Decimal|Select the character to represent the decimal point for columns determined to be containing numeric values, after splitting. | ||
Line 34: | Line 33: | ||
=====Remarks===== | =====Remarks===== | ||
- | Leading and trailing whitespace | + | Leading and trailing whitespace |
\\ | \\ | ||
=====Examples===== | =====Examples===== | ||
- | **Objective:** Extract the year, month, day, hour, and minutes from the timestamps.\\ | + | **Example:** Extract the year, month, day, hour, and minutes from the timestamps.\\ |
\\ | \\ | ||
**Source dataset:** | **Source dataset:** | ||
Line 58: | Line 57: | ||
\\ | \\ | ||
- | **Result:** | + | **Result |
^ Year ^ Month ^ Day ^ Separator1 ^ Hour ^ Separator2 ^ Minutes ^ | ^ Year ^ Month ^ Day ^ Separator1 ^ Hour ^ Separator2 ^ Minutes ^ | ||
| 2017|01 |02 |T |08 |: |31| | | 2017|01 |02 |T |08 |: |31| | ||
Line 64: | Line 63: | ||
| 2017|01 |04 |T |08 |: |15| | | 2017|01 |04 |T |08 |: |15| | ||
Use the [[transformations: | Use the [[transformations: | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/splitfixedwidthtext.txt · Last modified: 2021/08/14 21:47 by craigt