Hi,
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.
[ATTACH=CONFIG]29159[/ATTACH]