DSXchange

I have the following for the address:
AddressLineOne: 4999 BONITA BAY BLVD #1801
AddressLineTwo:
AddressLineThree:
City: BONITA SPRINGS
ProvinceStateType: FL
CountryType: USA
I am expcting the address should be coming out after ran throuh AVI Stage is: 4999 BONITA BAY BLVD UNIT 1801
I have the pattern action file with following values:
*\# | ^ ; # followed by numeric
RETYPE [1] U "#" "#" ; # retyped to unit type class

*\# | > ; # followed by leading numeric
RETYPE [1] U "#" "#" ; # retyped to unit type class

*\# | < ; # followed by leading alphabetic charater
RETYPE [1] U "#" "#" ; # retyped to unit type class

*\# | @ ; # followed by complex mix
RETYPE [1] U "#" "#" ; # retyped to unit type class

*\# | I ; # followed by initial
RETYPE [1] U "#" "#" ; # retyped to unit type class

*\# | D =T= "E","N","S","W" ; # followed by initial that is also direction (E,N,S,W)
RETYPE [1] U "#" "#" ; # retyped to unit type class


Please let me know if you have any suggestions. Thanks a lot in advance

Hi,

First, this appears to be normal QualityStage Standardization because you are asking about Pattern Action Language, which the AVI stage does not use.

Second, try change your code from to The changes the 'input' value and the 'standardized' value to 'UNIT', so 'UNIT' will be returned regardless of the subsequent COPY or COPY_A statement used.

Change the others, too, in the same manner.

Thanks a lot for your response!!!
I am actually trying to see if AVI Stage is capable of being configured such a way that once it receives # it should convert automatically change to UNIT for that particular address.
If you know any configuration changes that can make it happen please let me know.
FYI, CODE-1 PLUS Coding System can take the same address with # and return as UNIT. Thanks in advance!

You'll also find that the address rule sets in QualityStage can also handle the #1801 construct correctly. You might consider using these rather than the AVI stage. Or using both.

There are no configuration options that I am aware of that would cause AVI to produce a UNIT in place of a #.

You could, as Ray suggested, use both. You could also do something as simple as using AVI, and then using a Transformer to change all # to UNIT after, if that is your desire.

Taking a step back, the normal usages for AVI is:
1) Addresses from multiple countries
2) The need to 'verify' or 'validate' the address as a potentially real address. This is indicated in the return codes.

If your requirement is neither, then you may want to consider the out-of-the-box rule sets.