Differences

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

--- transformations:importtext [2018/08/15 08:18] – dmitry
+++ transformations:importtext [2021/03/04 19:20] – craigt
@@ Line 1: / Line 1: @@
-===== Import from delimited text file =====
+{{ transformations:ImportDelimitedTextAction.png}}
+======IMPORT FROM DELIMITED TEXT FILE======
+(Category: //Import | File//)
+=====Description=====
 This action loads data from one or multiple delimited text files.
-The number of columns in the resulting dataset is defined by the 1st row of imported data.
+The number of columns in the resulting dataset is defined by the first row of imported data.\\
+\\
+=====Action Settings=====
+^ Setting  ^ Description  ^
+|Load file| Fully-qualified file name of the dataset (includes relative or absolute path).  |
+|Encoding|ASCII, ANSI (with code page), and other types of encoding. If you're not sure what to choose, try UTF-8 as it's the most common Unicode encoding.|
+|Separator|The delimiter character that separates one value from another. For instance, for CSV files it should be a comma.\\ A custom separator consisting of up to 8 characters can also be specified.  If //No separator// is selected, all values are imported into a single field.|
+|Decimal|When a text value looks like a number, EasyMorph converts it into a number. The decimal character specifies whether such numbers should have comma or dot as decimal separator.|
+|Skip first lines|This option specifies how many lines to skip from the beginning of a file. It can be helpful in case when first rows contain\\ some metadata (file header) and actual tabular data starts only after that metadata. This setting can be specified using a parameter as well.|
+|Columns don't have headers|Check this if data doesn't have column headers.|
+\\
+=====Advanced Options=====
+^ Setting  ^ Description  ^
+|Show parsing errors|Check this to add a column that contains parsing errors (if any) for each line. It can help detect rows that have too few values, or too many values.|
+|Ignore quoting|By default, values wrapped in double quotes can contain the separator character and line breaks. Check this option if wrapping double quotes should be treated as regular characters.|
+|Maximum number of lines to load|Limits the number of rows loaded from the file. This setting is applied after //Skip first lines//. Use "0" to load all rows.|
-**Options**
+\\
+=====Importing Multiple Files=====
+This action can import multiple files.  See [[import:fileimportmodes|Importing Multiple Files]] for more information.\\
+\\
+=====Use cases=====
+Use the ''Import from delimited text file'' action when you have a plain text, structured, data file with fields that are separated by a delimiting character.  In the case of a file having //no// embedded delimiters, all values are importing into a single field.\\
+\\
+=====Examples=====
+A __pipe-delimited__ .txt file to be imported __starts with 3 rows of metadata__ and has __no header rows__.
+<code>
+...
+Data to import
+---
+|12|3.5|red|265
+|47|4.55|teal|354
+|4|8.1|burgundy|380
+</code>
-//Encoding// - ASCII, ANSI (with code page), and other types of encoding. If you're not sure what to chose, try UTF-8 as it's the most common Unicode encoding.
+Use the following settings:
+>  Separator = "Pipe"
+>  Skip first lines = "3"
+>  Columns don't have headers = [X] (checked)
-//Separator// - the delimiter character that separates one value from another. For instance, for CSV files it should be comma. A custom separator consisting of up to 8 characters can also be specified.
+Output:
+|1|12|3.5|red|265
-//Decimal// - when a text value looks like a number, EasyMorph converts it into a number. The decimal character specifies whether such numbers should have comma or dot as decimal separator.
+|2|47|4.55|teal|354
+|3|4|8.1|burgundy|380
-//Skip first lines// - this option specifies how many lines to skip from the beginning of a file. It can be helpful in case when first rows contain some metadata (file header) and actual tabular data starts only after that metadata. This setting can be specified using a parameter as well.
-//Columns don't have headers// - check this if data doesn't have column headers.
-**Advanced options**
-//Show parsing errors// - check this to add a column that contains parsing errors (if any) for each line. It can help detect rows that have too few values, or too many values.
-//Ignore quoting// - by default, values wrapped in double quotes can contain the separator character and line breaks. Check this option if wrapping double quotes should be treated as regular characters.
-//Maximum number of lines to load// - limits the number of rows loaded from the file. This setting is applied after //Skip first lines//. Use 0 to load all rows.
+\\
+=====See Also=====
+  * [[transformations:importfixedwidthtext|Import fixed width text file]]
+  * [[transformations:importplaintext|Import plain text]]
+  * [[transformations:filesplitter|Split delimited text file]]