The following table explains the schema settings for delimited data sources.
Option | Description |
---|---|
Characters | |
Delimiter |
Select a delimiter from the list provided. If the delimiter that you require is not shown, click Advanced to specify:
Example
Note: An extended ASCII character can be a delimiter.
Note: If you want to use a three-character delimiter, type in the delimiter to
the Delimiter drop-down box.
|
Quote |
If your data uses characters to group strings together, you must select the character that represents the grouping. For example, if your file is comma delimited, but one of the columns of data contains the value "Edinburg, Texas", then you would select double-quote (") as the character to use to group the string: Edinburg, Texas. If the character you want to use is not shown in the drop-down list, click Advanced to specify:
Note: An extended ASCII character can be a quote.
|
Attribute Information | |
No information | Select if there are no column names on the first line. |
Names on first line | Select if there are column names on the first line. |
DDL | Select if this data file has a corresponding DDL. A Schema Selection window will appear where you can select the DDL that matches this delimited data file. |
Miscellaneous | |
Records are CR/LF terminated |
Specify how end of lines are represented in the data file.
|
Character Encoding | Specify the character encoding for the data. ASCII is the most commonly used. |