-
Delimiter - select the character that delimits field values
in the source file:
|- default delimiter for .psv (pipe-separated value) files\t- (tab) default delimiter for .tsv (tab-separated value) files,- default delimiter for .csv (comma-separated value) files and all other types of text files
-
Escape Character - select the character used to escape
special characters (like the field delimiter) found within field values; e.g.,
a
\might be used to escape commas within field values in a .csv file - Comment Identifier - select the character(s) with which comment lines within the source file begin
-
Quote Character - select the character used to quote field
values; e.g., a
"might be used to quote field values containing commas in a .csv file - Null Identifier - select the character(s) used to identify null field values
- Has Header - check the box if the source file contains a header row at the top
Import Source
If the source data is in a delimited text file, options for parsing the file can
be specified (see Delimited Text Options for details):