Topic
3 replies Latest Post - ‏2008-08-15T08:19:55Z by Ray.Wurlod
SystemAdmin
SystemAdmin
533 Posts
ACCEPTED ANSWER

Pinned topic QS 7.5 USADDR.pat inserts word HIGHWAY

‏2008-07-29T12:39:39Z |
I have replaced my rulesets with the original, clean, rulesets that installed with the client and get the same result. I am processing data presented to me as Name, address1, address2, address3, address4 and within the 4 lines of address is contained city, state, postal. In cases where there is a ' ,' space comma anywhere in the address lines, the word HIGHWAY is getting inserted and the city, state, postal is erroneously added to the address domain. I can override the pattern to put the city, state, postal in the area domain, but I still worry that there could be ' ,' in an address that will get HIGHWAY insert erroneously. I can of course replace the ' ,' in the ETL on initial load, but I am wondering if anyone else has encountered this - or if IBM has a ruleset fix available. I am pretty sure the problem lies within USADDR.PAT. Not having gone through 'advanced training' the pattern file looks mostly like gibberish to me. I do see many locations where 'HIGHWAY' is getting replaced into a pattern, but I am not confident that I can fix this myself.

Name Domain Address Domain Area Domain Unhandled Address Data
SMITH PROPULSION PO BOX 1999 JOHNS ISLAND , SC 29457
JOHNS ISLAND SC HIGHWAY 29457
SMITH BROTHERS INC 41515 LIBERTY BELL DRIVE WILLIAMSVILLE , NY 142217090
WILLIAMSVILLE NY HIGHWAY 142217090
Updated on 2008-08-15T08:19:55Z at 2008-08-15T08:19:55Z by Ray.Wurlod
  • Ray.Wurlod
    Ray.Wurlod
    18 Posts
    ACCEPTED ANSWER

    Re: QS 7.5 USADDR.pat inserts word HIGHWAY

    ‏2008-08-09T01:19:03Z  in response to SystemAdmin
    Take a look at the Pattern Action Language manual. It's not all that difficult.
    • SystemAdmin
      SystemAdmin
      533 Posts
      ACCEPTED ANSWER

      Re: QS 7.5 USADDR.pat inserts word HIGHWAY

      ‏2008-08-12T13:36:27Z  in response to Ray.Wurlod
      Thanks for the tip. I will check it out. 80 pages doesn't seem TOO bad. It now seems the issue is created when area info is misidentified in the preprocessor as address info (ie, two word city names). As I handle the field patterns to get the area info into the area domain, while the issue remains, it is resolving as the data gets classified correctly.

      -Beth Carey
      • Ray.Wurlod
        Ray.Wurlod
        18 Posts
        ACCEPTED ANSWER

        Re: QS 7.5 USADDR.pat inserts word HIGHWAY

        ‏2008-08-15T08:19:55Z  in response to SystemAdmin
        More specifically, then, look at the USPREP rule set. Find out why HIGHWAY (standard form) is being identified as area domain rather than address domain. It may be enough to examine the classification table for USPREP.