User Tools

Site Tools


transformations:importtext

Import from delimited text file

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.

Options

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.

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.

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

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.

transformations/importtext.txt · Last modified: 2018/08/15 12:18 by dmitry