Special Apartment Number Processing - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

If you have apartment number entries that contain a pound sign (#) and you want to parse it as an apartment number while keeping the # character, you can use a special apartment number processing.

By default, the CDP converts all # characters to spaces by the characters control file (charctl.win/unx, located in ./tables/parser_rules). As a result, if the address has the # character, it will be converted to a space before parsing begins. For example, "23 Davis Rd., #C4" becomes "23 Davis Rd.,  C4". "C4" will still be parsed as the dwelling number, but the dwelling type is a '?' (no type) instead of 'A' (apartment), and the dwelling name will not include the # character.

To process the # character as apartment number correctly, you will need to remove or comment out the # character from the characters control file so that the CDP will recognize the # character as a dwelling type of apartment.

To edit the characters control file

  1. From the Navigation or Project View, right-click Customer Data Parser and select Edit Process.
  2. Select the Advanced Rules menu option. The paths and names of the default rules files are displayed in the appropriate fields.
  3. Click Copy to client for the Characters control file.
  4. Select a destination folder and click OK.
  5. Go to the destination folder and open the file using a text editor.
  6. Remove or comment out the # character from the file.
  7. After your change is saved return to the Advanced Rules window and click Upload.
  8. Click Finish. The default version of the control file remains intact. A new version, identified by the process number, is saved in the table directory under the project folder (for example, C:/ProgramData/Trillium Software/Data/metabase/<repository_name>/project4/tables/p30_charctl.win).

    Notes

    Be aware that if the # character is used with a number that is not an apartment number, then the CDP will parse the number differently. For example, consider the address line:

        RR 11 Box #7

    With the default processing, it would be parsed as the following, which would be desirable.

    Input

    RR

    11

    Box

    #7

    Attribute RTE RTE-NUM BOX BOX-NUM

    With the special apartment number processing, it would be parsed as the following, which would not be desirable in this case.

    Input

    RR

    11

    Box

    #

    7
    Attribute RTE RTE-NUM STR-NM APT APT-NUM