Analyst Tool Guide

Back Next

Flat File Options

When you import a flat file data object, you can configure the flat file options for each column in

Add Flat File

wizard. The options that you configure determine how the wizard reads the data from the source flat file.

You can configure the following flat file options in the

Add Flat File

wizard:

Code Page: Code page of the data in the flat file object. Select a code page that matches the code page of the data in the flat file object.
Delimiters: Character used to separate columns of data. Use the Other field to enter a different delimiter. Printable characters must be different from the escape character and the quote character if selected. You can input the following non-printing multibyte characters:
\1
,
\01
, or
\001
.
Text Qualifier: Quote character that defines the boundaries of text strings. Choose No Quote, Single Quote, or Double Quotes. If you select a quote character, the wizard ignores delimiters within pairs of quotes.
Column Names: Option to import column names from the first line. Select this option if column names appear in the first row. The wizard uses data in the first row in the preview for column names.

If the first row contains numeric characters, the wizard uses COLUMNx as the default column name. If the first row contains special characters, the wizard converts the special characters to underscore and uses the valid characters in the column name. The wizard skips the following special characters in a column name: " . + - = ~ ` ! % ^ & * ( ) [ ] { } ' \ " ; : ? , < > \ \ | \t \r \n. Default is not enabled.
Values: Option to start value import from a line. Indicates the row number in the preview at which the wizard starts reading when it imports the file.