City Changes File - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

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

  • x1 is low range of characters that is replaced
  • x9 is high range of characters that is replaced
  • x2,x3 is the first character sequence to replace x1
  • x4 is the second character sequence to replace x1

 

Examples

  • U00C2-U00C3=U0041

Accented capital As (Â and Ã) will be replaced with 'A' for the city name lookup.

  • U00C4=U0041/U0041,U0045

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.