Single column address and area parsing with no separators

mczern · Post by **mczern** » Thu Feb 23, 2012 11:29 am

I am fairly new to using QualityStage and I've searched the forum for an answer but to no avail. I have to get an answer by tomorrow AM Eastern time or QualityStage will not be used. So, I'm looking to the gurus out there to provide some advice on this!!

I have a single column field with several different address/area formats contained within. (A representative sample below). I am using USADDR and USAREA to parse out the address info. I can usually parse out the state and zip without problems. However the Address and City info is not cooperating. I think 'overrides' can be utilized, but I'm not savy on using them yet. Can the address and city info be reliably broken into separate fields using Quality Stage? Seems like the answer is yes.

If anyone could provide some guidance it would be GREATLY appreciated!

100 SHORE RD NIANTIC CT 06357-1000
100 NEW RD MADISON CT 06443-1000
1000 ROUTE 66 GUILFORD CT 06437-1000
C-O SMITH JONES 100 BEACH ST BLDG Z WESTERLY RI 02891-1000
1000 ROUTE 66 GALES FERRY CT 06335-1000
SYSTEM RESEARCH DEPT RDC 100 1000 SOCKANOSSET CROSS ROAD CRANSTON RI 02920
200 FERRY RD CHESTER CT 06412-1000
C-O US COMPANY 100 WILLIAMS ST NEW LONDON CT 06320-1000
100 W SHORE DR CLINTON CT 06413-1000
100 R 1 LONG POND RD LEDYARD CT 06339
100 PARKWAY S NEW LONDON CT 06320-1000
100 ROUTE 66 GALES FERRY CT 06335-1000
100 MEADOW POINT RD WESTBROOK CT 06498-1000
C/O THIS PERSON & CO 100 W MAIN ST NORWICH CT 06360-1000

rjdickson · Post by **rjdickson** » Thu Feb 23, 2012 3:50 pm

Hi,

Please try the USPREP ruleset with ZQMIXRZQ as a literal before your one column data. The output from USPREP gives you three columns: NameDomain, AddressDomain, and AreaDomain. It will probably not be perfect, but may give you something close to what you need.

ZQMIXRZQ is explained here.

mczern · Post by **mczern** » Thu Feb 23, 2012 9:27 pm

Thanks a ton!
It worked well enough that although some of the Cities did not parse out of the address line, the state and zip code were enough to use to get the city later.

I'm sure there is a way to parse the field better. But this solves the problem well enough.