transformations:importtext
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
transformations:importtext [2015/01/31 15:00] – created dmitry | transformations:importtext [2021/08/14 21:20] – [Action settings] craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Import from delimited text file ===== | + | {{ transformations: |
+ | ======IMPORT DELIMITED TEXT FILE====== | ||
+ | Category: Import / File\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | 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.\\ |
+ | \\ | ||
+ | =====Use cases===== | ||
+ | Use the //Import from a delimited text file// action when you have a plain text, structured, data file with fields that are separated by a delimiting character. | ||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^ Setting | ||
+ | |Load file< | ||
+ | |Encoding|ASCII, | ||
+ | |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. | ||
+ | |Decimal|When a text value looks like a number, EasyMorph converts it into a number. The decimal character specifies whether such numbers should have a comma or a dot as the decimal separator.| | ||
+ | |Thousand|When a text value looks like a number, EasyMorph converts it into a number. Select the separator used to define the thousands places within the value. | ||
+ | |Skip first lines< | ||
+ | |Columns don't have headers|Check this if data doesn' | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | ====Advanced options==== | ||
+ | ^ Setting | ||
+ | |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< | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | Preview the raw and imported versions of the dataset using the //Show preview// button at the top of the action settings window.\\ | ||
+ | |||
+ | This action can import multiple files. | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Input:** | ||
+ | < | ||
+ | ... | ||
+ | Data to import | ||
+ | --- | ||
+ | 1|12|3.5|red|265 | ||
+ | 2|47|4.55|teal|354 | ||
+ | 3|4|8.1|burgundy|380 | ||
+ | </ | ||
+ | |||
+ | The input text has the following properties: | ||
+ | * pipe-delimited .txt | ||
+ | * starts with 3 rows of metadata | ||
+ | * has no header rows | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Separator is Pipe | ||
+ | > Skip the 3 first lines | ||
+ | > Columns don't have headers (checked) | ||
+ | |||
+ | \\ | ||
+ | **Result table:** | ||
+ | | 1| 12| 3.5|red| | ||
+ | | 2| 47| 4.55|teal| | ||
+ | | 3| 4| 8.1|burgundy| | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | ]] ([[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====Shortcuts===== | ||
+ | Fast ways to create the action: | ||
+ | * Press the "Add data" menu button. Pick " | ||
+ | * Drag a text file into the application window. Supported file extensions: csv, psv, tsv. | ||
+ | * Drag a folder with text files into the application window. | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
transformations/importtext.txt · Last modified: 2023/10/11 20:48 by craigt