I was given a list of names of addresses in an Excel file in the format below
Column A Column B
Name Street Address Suite
City State Zip
I can remove the merge from column A but how do i get the city state zip in the rows to column C in the appropriate rows?
Solved! Go to Solution.
Hi @parria1
Please see below for the workflow:
This is the dataset
And the workflow is pretty simple
You then can see how we locate the row with the info that is supposed to be column C and assign it to over there.
Pedro.
Thanks Pedro, this does not work with actual addresses, so i changed the field3 to 250 length and it works.
My other problem is now i need to parse out the city,state,zip field because i need to perform an address match to our database. the CASS tool will not export out the city, state,zip in separate fields like i had hoped. any ideas here?
I am able to parse out the state and zip into separate fields but how about the city? the cities with two names separated by a space are giving problems.
The CASS tool will export the city with the correct State and Zip parsed into separate fields.