City Changes FileCustomer Data Parser (CDP);Global Data Router - trillium_discovery - trillium_quality - Latest

Inline Quality and Discovery

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

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.