Entries added to the city changes file for the Customer Data Parser and Global Data Router instruct the process to use the specified characters and words to look up city names. By using this secondary table, the process can obtain better matching in table lookup.
Guidelines
- The Use city changes file option in the CDP and the Router must be selected to use the city changes file.
- Country-specific parameters are entered in the Country section of the city changes file.
- Entries in the city changes file are case-insensitive.
- The city changes file is encoded in UTF8.
- The CDP and the Router automatically convert hyphens to spaces. They also drop short words (3 characters or less) in the middle of the string. Entries with apostrophes are looked up without the apostrophe, and with the apostrophe changed to a space.
Parameter |
Description |
---|---|
REPLACE_CHARACTER |
Allows you to replace characters that are used for the lookup of city names. Syntax REPLACE_CHARACTER x1-x9 = x2, x3/x4 where
Examples
Accented capital As (Â and Ã) will be replaced with 'A' for the city name lookup.
Capital As with umlaut (Ӓ) will be replaced with 'A' and also be replaced with "A E" for the city name lookup. |
SWAP_WORD |
Allows you to swap words if any of the words listed is found. Syntax SWAP_WORD word1, word2, word3
Example COUNTRY IT SWAP_WORD saint, san, sant, santa, santo, st, sur |
For information about opening and editing the file, see Editing Advance Rules for the Customer Data Parser or Global Data Router.