Skip to Content
0

US/Global Address cleanse with only city and postal code

Aug 25, 2017 at 04:18 PM

64

avatar image
Former Member

Hello,

I am currently trying to standardize two fields. One contains ship to locations and the other had postal code information. The data contains both US and International addresses and this table does not contain a street name or address.

Currently I am using US address cleanse and decode statements to divide up the records into either US or Global addresses (some records contain the country along with the city), however has anyone faced such a requirement and what was the best course they took? My main idea is to divide up the US and the Global addresses and then run them through either the US transform or the Global address transform.

Would it be better to put the ship to and zip-code into multi-line fields? Are there also any option settings that can be enabled in either transform to improve accuracy? Any advice would be appreciated.

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers