Analyzer flat file settings govern the connections between Analyzer and your data files. Analyzer organizes its connection settings into three pages:
To access these settings from the Project view, right-click a flat file profile, then select
. You can modify the settings in any of these pages. Click or to save your changes.The File Path page contains the following settings:
Table 2-9 File Path Settings
Setting |
Description |
---|---|
|
Specifies the path to the desired file. |
|
Specifies the character encoding used in the specified file. The default setting is UTF-8. |
The Delimiter Settings page contains the following settings:
Table 2-10 Delimiter Settings
Settings |
Description |
---|---|
|
Specifies a name for the flat file profile. This name is used for the profile object in the Project View. By default, this is the filename, but you can use any name you want. |
|
(Optional) Specifies a more detailed description for the flat file profile. |
|
Specifies the object class to which the attribute values in the selected file should be associated. For example, a file of user information should be associated with the User class. |
|
Specifies the field delimiter used in the selected file. The default setting is a comma. |
|
Specifies the character used to enclose values that contain the field delimiter as part of the value. You can choose between double quotes (“ ”) and single quotes (‘ ’). |
|
When this option is selected, Analyzer treats the first row of the data file as field names. Analyzer treats these field names as attribute names, so they should match the appropriate attribute names in the associated Object Class. |
The Field Names page lets you modify the field names used in the flat file profile.
By default, Analyzer displays generic field names if
is not selected in the Delimited Text Settings dialog box. If is selected, Analyzer lists the values in the first data row as the field names. Regardless of the values initially displayed, you can adjust the field names after they are created.