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.
|