Schema Settings for Delimited Data Sources - 17.1

Inline Quality and Discovery

Version: 17.1
Language: English
Product name: Trillium Quality and Discovery
Title: Inline Quality and Discovery

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: Decimal or hexadecimal (HEX) representation of the character. Double delimiters, such as \|\|. 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: Decimal or hexadecimal (HEX) representation of the character. Double delimiters, such as \|\|. 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. Windows text applications typically apply CR/LF line delimiters, while UNIX typically applies LF. The preview pane will attempt to display end of line characters. These characters will differ depending on which font is selected.
Character Encoding	Specify the character encoding for the data. ASCII is the most commonly used.