Differences

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

--- transformations:splitfixedwidthtext [2021/04/21 15:30] – [Description] craigt
+++ transformations:splitfixedwidthtext [2021/08/14 21:47] (current) – [Action settings] craigt
@@ Line 11: / Line 11: @@
 \\
 =====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.\\
@@ Line 18: / Line 18: @@
 =====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.  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.|
 |New columns|Refer to the table below for //new column// settings.|
@@ Line 34: / Line 35: @@
 =====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=====
-**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:**
@@ Line 58: / Line 59: @@
 \\
-**Result:**
+**Result table:**
 ^ Year ^ Month ^ Day ^ Separator1 ^ Hour ^ Separator2 ^ Minutes ^
 | 2017|01 |02 |T |08 |: |31|
@@ Line 64: / Line 65: @@
 | 2017|01 |04 |T |08 |: |15|
 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//)
 \\