Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Common Components of the Siebel Customer-Centric Enterprise Warehouse > Configuring Extracts >

Setting Up the Delimiter for Source Files

You must make sure that the delimiter used in the CSV files is not present in the source data. Siebel Customer-Centric Enterprise Warehouse is preconfigured with a comma as the source file delimiter. If your data contains commas, than you need to enclose the data fields using a character that is not present in the data set. For example, common enclosing characters include single quotes and double quotes.

To set up the delimiter for source files

1. Open the CSV file.
2. Enclose the data fields with the enclosing character that you have identified.

   You can identify an enclosing character by identifying a character that is not present in the source data. Common enclosing characters include single quotes and double quotes.

3. Save and close the CSV file.
4. Identify all the source definitions associated with the modified files.
5. Change the properties for each of these source definitions to use the enclosing character.
6. Validate and save your changes to the repository.