For addresses, there are numerous web services that will take the address, verify that it is valid and send it back in structured format. This one is nice: https://webgis.usc.edu/Services/AddressValidation/Default.aspx
On Mon, Feb 8, 2010 at 2:19 PM, Susan Murray <[email protected]> wrote: > > I can't tell you how many hundreds of times I've dealt with this problem! > Sometimes it is easier to just use Excel and fix the data manually, > sometimes I have written code to run through and do the parsing, but with > "non-standard" delimiters, it would probably be a nightmare. Some utilities > I've used have to run through the records multiple times... ie, one time to > normalize delimiters, etc. I agree, have your boss at the very least remove > contacts that he doesn't want retained, that will save you some tim ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3273 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
