EasyMorph Help

User Tools

Site Tools

You are here: start » transformations » splitfixedwidthtext
transformations:splitfixedwidthtext

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
transformations:splitfixedwidthtext [2021/04/21 08:10] – craigttransformations:splitfixedwidthtext [2021/08/14 21:47] (current) – [Action settings] 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:importfixedwidthtext|Import fixed width text]] action with the difference being that it works with the already loaded dataset.\\ This action splits text values of the selected column into multiple columns of values of specified lengths. It is similar to the [[transformations:importfixedwidthtext|Import fixed width text]] action with the difference being that it works with the already loaded dataset.\\
  
-**Show preview:**  Preview the raw version of the column using the //Show preview// button at the top of the action settings window.\\+**Show preview:**  Preview the raw version of the column's data, and the post-split results, using the //Show preview// button at the top of the action settings window.\\
  
 \\  \\ 
 =====Use cases===== =====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.\\+Use this action when you have a column of text-based data in which the individual values are defined by //positioning// (spaces, tabs, etc.) rather than delimiting characters, and you need to separate them into columns.\\
 \\  \\ 
 If your data has //delimeters//, use the [[transformations:splitdelimitedtext|Split delimited text into columns]] or [[transformations:subfield|Split delimited text into rows]] action, instead.\\ If your data has //delimeters//, use the [[transformations:splitdelimitedtext|Split delimited text into columns]] or [[transformations:subfield|Split delimited text into rows]] action, instead.\\
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.  Options:  //Point// or //Comma//.|+|Decimal separator|Select the character to represent the decimal point for columns determined to be containing numeric values, after splitting.  Options:  //Point// or //Comma//.| 
 +|Thousand separator|Select the character to represent thousands places for columns determined to be containing numeric values, after splitting.  Options:  //Default//, //Comma//, //Point// or //Space//.| 
 +|Treat numeric values|Select how EasyMorph should handle numeric values.  Options: //Always as numbers// or //Always as text//. |
 |Keep original column|When selected, the source column will remain in the dataset.| |Keep original column|When selected, the source column will remain in the dataset.|
 |New columns|Refer to the table below for //new column// settings.| |New columns|Refer to the table below for //new column// settings.|
Line 34: Line 35:
  
 =====Remarks===== =====Remarks=====
-Leading and trailing whitespace is automatically removed from values when the new columns are created.\\+Leading and trailing whitespace are automatically removed from values when the new columns are created.\\
  
  
 \\  \\ 
 =====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 59:
  
 \\  \\ 
-**Result:**+**Result table:**
 ^ 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 65:
 | 2017|01 |04 |T |08 |: |15| | 2017|01 |04 |T |08 |: |15|
 Use the [[transformations:keepremovecolumns|Keep/Remove columns]] action downstream to remove the "Separator" columns if not needed. Use the [[transformations:keepremovecolumns|Keep/Remove columns]] action downstream to remove the "Separator" columns if not needed.
 +
 +\\ 
 +====Community examples====
 +  * [[https://community.easymorph.com/t//1972/2|Read Data with two line header]] ([[https://community.easymorph.com/uploads/short-url/4YFQxslIv3pmgtF2eRywf4wpcFQ.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Headers//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//2454/2|.txt to .csv - Multiple Line & Character Length HELP!]] ([[https://community.easymorph.com/uploads/short-url/6zwA1kxDaRgN7GvTUUmi8r1Qgn4.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Type 01//; Action position: //4//)
 +  * [[https://community.easymorph.com/t//2008/2|“Printed” Text File: Could EasyMorph import this?]] ([[https://community.easymorph.com/uploads/short-url/kIb1qqOJb9WK6D1N1jFZdnHzC46.morph|Project]]; Module: //Parse Group//; Group: //Tab 1//; Table: //Header//; Action position: //3//)
  
 \\  \\ 
transformations/splitfixedwidthtext.txt · Last modified: 2021/08/14 21:47 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki