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:
|
Character Encoding | Specify the character encoding for the data. UTF-8 is the default. |