Setting File Delimiters

File delimiters separate data-source fields. Outside rules files, data-source fields are delimited by spaces. Within rules files, by default, data-source fields are delimited by tabs.

Within data load or dimension build rules files, you can set commas, tabs, white spaces, fixed-width columns, or custom values as file delimiters. You need not set file delimiters for SQL data. File delimiters set for SQL data are ignored.

  To set file delimiters:

1. Open or create the rules file.

2. Select Options, then Data source properties.

3. In the Data Source Properties dialog box, select the Delimiter tab.

4. In the Delimiter node, select a file delimiter.

5. If you selected a custom file delimiter, in the text box, enter a character from the standard ASCII character set, from 0 to 127.

6. If you selected fixed-width columns, in the text box, enter the column width.

Related Information

• Creating a Data Load Rules File

• Creating Dimension Build Rules Files

• Data Source Properties Dialog Box, Delimiter Tab