# is not converting to UNIT after ran through AVI Stage

mahmudul · Post by **mahmudul** » Thu Jul 05, 2012 2:00 pm

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

rjdickson · Post by **rjdickson** » Thu Jul 05, 2012 2:20 pm

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

Code: Select all

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

to

Code: Select all

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

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.

mahmudul · Post by **mahmudul** » Fri Jul 06, 2012 9:50 am

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!

ray.wurlod · Post by **ray.wurlod** » Fri Jul 06, 2012 4:09 pm

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.

rjdickson · Post by **rjdickson** » Mon Jul 09, 2012 6:36 am

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.