US Address Standardization

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
reachsam11
Participant
Posts: 26
Joined: Wed Mar 17, 2010 11:05 am

US Address Standardization

Post by reachsam11 »

What should be the override pattern for the below addresses
Is there a way i can overide to force 'ATTN: POSTMASTER' to Additional Address column, no matter what the input pattern is. There are about 100+ diff input/unhandled patterns starting with 'ATTN: POSTMASTER'

Address (Input Pattern)
-------------------------------------------
ATTN: POSTMASTER RTE 222 A MAIN ST ( E+R^I+T )
ATTN: POSTMASTER RT 111 MAIN ST ( E+R^+T )
ATTN: POSTMASTER MILE 666 RCHRDSN HWY ( E++^+T )
ATTN: L GONZALEZ 1234 W 55RD AVE PL ( EI+^D>TT )
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I take it you don't want to create your own rule set and modify the Pattern Action Language.

You could use an input pattern override with a pattern that begins with the literal. I am not sure how you need to handle GONZALEZ in your example.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Re: US Address Standardization

Post by stuartjvnorton »

reachsam11 wrote:What should be the override pattern for the below addresses
Is there a way i can overide to force 'ATTN: POSTMASTER' to Additional Address column, no matter what the input pattern is. There are about 100+ diff input/unhandled patterns starting with 'ATTN: POSTMASTER'

Address (Input Pattern)
-------------------------------------------
ATTN: POSTMASTER RTE 222 A MAIN ST ( E+R^I+T )
ATTN: POSTMASTER RT 111 MAIN ST ( E+R^+T )
ATTN: POSTMASTER MILE 666 RCHRDSN HWY ( E++^+T )
ATTN: L GONZALEZ 1234 W 55RD AVE PL ( EI+^D>TT )

You could do something like this in PAL:

E | ** | R
COPY_S [2] tmp
PREFIX " " tmp
PREFIX [1] tmp
COPY tmp {AdditionalAddressInfo}
RETYPE [1] 0
RETYPE [2] 0

E | ** | ^
COPY_S [2] tmp
PREFIX " " tmp
PREFIX [1] tmp
COPY tmp {AdditionalAddressInfo}
RETYPE [1] 0
RETYPE [2] 0

You might need more like them to stop at unit types, level types, etc.
In the examples above, should "MILE" be an R?
Post Reply