Character entries added to the delimiters control file for the CDP and BDP instruct the process to use the specified characters as word delimiters. You also tell the parser to include or exclude the characters in the table lookup. The parser uses the comma (,) space ( ), and period (.) as default delimiters, and are excluded in table lookups unless otherwise specified.
Guidelines
- Modified advanced rules files only apply to the current process; changes you make do not affect other projects or other processes in your workflow.
- The British Pound (£) and the Not sign (¬) characters are not supported as delimiters in Quality processes.
For information about opening and editing the file, see Editing Advance Rules for the Customer Data Parser or Business Data Parser.
Defining Delimiters
For each delimiter character you include, you assign values that define how the parser should handle the characters. The following shows a delimiters control file that includes the three default delimiters and one additional character value:
The following table describes the values shown above:
| Values | Description |
|---|---|
| 0 , | Use a comma as a delimiter. Exclude commas from the lookup process. |
| 0 |
Use a space as a delimiter. Exclude spaces from the lookup process. |
| 0 . | Use a period as a delimiter. Exclude periods in the lookup process. |
| 1 & | Add an ampersand as a delimiter. Include ampersands in the lookup process. |
Column 2 is not used and should be left empty.
Example
Say you have fields in your records separated by pipes. You have no other special characters in your data. You would remove the default delimiters and add pipes to the delimiters control file to direct the parser to read pipes as field separators.