Schema Options for Delimited Data Sources - trillium_discovery - Latest

Inline Discovery

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Discovery
Title
Inline Discovery
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

The following table explains the schema settings for delimited data sources.

Option Description
Delimiter

Select a field delimiter from the drop-down list. Comma is the default.

Text Qualifier

If your data uses characters to group strings together, 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 used to group the string: Edinburg, Texas. Double-quote is the default.

Record Termination

Select CR/LF (carriage return/line feed) to specify how end of lines are represented in the data source. Note the following:

  • Windows text applications typically apply CR/LF line delimiters, while UNIX typically applies LF.
  • The Data Preview will attempt to display end of line characters.
Character Encoding Specify the character encoding for the data. UTF-8 is the default.