DSXchange

Hi,
I am using standardize stage to seperate US city and state from one field, I am able to do correctly with first record and rest of records are comeing out with no change , applied USAREA rule,

Is there white space between city and state in this field? Is state abbreviated or in full, or a mixture? Have you run any investigation over the data to determine which tokens are being identified as which under the USAREA rule? If so, what are the results of that investigation. You may need to design in some user overrides to bucketize city and state properly out of a single free-form field.