search

google-code-export / bluesquared

Automatically exported from code.google.com/p/bluesquared
0 stars 0 forks source link

BatchMaker: Split City, State, Zip #126

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Import the City, State and Zip (if combined) into the Address1 column, then 
create a r-click context menu to "split" them apart.

First split by using Comma's delimited (Keep everything before the comma in 
that column), move the City and zip to the City Column, remove spaces, then 
move all data over two characters to the zip column.

Original issue reported on code.google.com by casey.ac...@gmail.com on 20 Feb 2014 at 10:56