Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements

 | Shopping Cart Buy | Newsletters | Search

    Products         Solutions       Downloads & Trials       Support          Resources         Lookups       Contact Us  

Logged in as: Guest Search | Active Topics |

Personator won’t parse a field containing an Address and CityStateZip Options · View
Tim61468773
Posted: Tuesday, January 29, 2008 1:54:32 PM
Groups: Administration

Posts: 16
Personator recognizes addresses as an Address datatype, and CityStateZip’s as a different datatype - a combination of City, State and Zip and/or Postal datatypes. Therefore it will not correctly parse both data types in one field.

12 Main St. South Anytown, ST 99999

Is the ‘South’ an address post-directional, or is the city ‘South Anytown’? Personator can’t make that determination. Perhaps an address verification solution will help you. Simply put, your addresses should reside in a different field from your City, State, Zip data to be parsed correctly.

What if I have a delimiter separating these two datatypes? like…

12 Main St. : South Anytown, ST 99999

…here you’re in luck. Use the Namesplit process, and split this field by delimiter (in this case “:”). This will separate your Address from your CityStateZip into 2 different fields, which can then be run through an Address or CSZ split.
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by Yet Another Forum.net