|
Setting Delimited Text Properties
The following settings may be modified when working with delimited text files imported as databases.
q First row contains column names – Check this box to indicate that the first row of the file contains column names
q Delimiter character – Specifies the delimiter (i.e., comma, tab, semicolon, pipe, space, other) used in the file to separate values
q Quoted values may contain embedded line breaks – Check this box if values may run beyond one line (i.e., the value includes a line break)
q Text qualifier – Specifies what character is used (i.e., double quote, single quote, none) to enclose values. When Monarch encounters this qualifier in a line, all of the text following this character and preceding its next instance is imported as one value, regardless of the delimiter used (see Note below).
q Character set – Specifies the type of encoding to use when interpreting data
q Lines to skip at start – The number indicated in this box instructs Monarch to skip n lines before beginning data import
|
|
NOTE Delimiter vs. Qualifier Example: If the delimiter is a comma (,) and the text qualifier is a double quotation mark ("), "Boston, Massachusetts" is imported into one cell as “Boston, Massachusetts.” By contrast, if no character or the single quotation mark (') is specified as the text qualifier, "Boston, Massachusetts" is imported into two adjacent cells as "Boston" and "Massachusetts." |
|
