Differences

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

--- transformations:importtext [2015/01/31 15:00] – created 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//)
-This transformation loads data from a delimited text file.
+=====Description=====
+This action loads data from one or multiple delimited text files.
-File name should include full or relative path.
+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.|
+\\
+=====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>
+Use the following settings:
+>  Separator = "Pipe"
+>  Skip first lines = "3"
+>  Columns don't have headers = [X] (checked)
+Output:
+|1|12|3.5|red|265
+|2|47|4.55|teal|354
+|3|4|8.1|burgundy|380
+\\
+=====See Also=====
+  * [[transformations:importfixedwidthtext|Import fixed width text file]]
+  * [[transformations:importplaintext|Import plain text]]
+  * [[transformations:filesplitter|Split delimited text file]]