Standardize addresses tool

Discussion created by k_eggering on Nov 17, 2013
Latest reply on Dec 2, 2013 by jborgion

I'm just wondering how I can parse an apartment/building number out of an address.  I have an excel sheet that has 1100+ addresses, and about half of them are in the "123 Hwy 24, #456" format.  In this format they are not able to be standardized.  I've tried changing the # sign to Apt, Bldg, and various other things.  Changing the format to "123 Apt 456 Hwy 123" doesn't work either, and I'm not sure how I would make that change to all 500+ fields (i.e. find and replace wouldn't work).  This is the first post I've created.  I hope I'm following protocol/etiquette, apologies if I've forgotten something.