Special Apartment Number Processing - trillium_discovery - trillium_quality - Latest

Trillium Control Center

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

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