I have a text file containing company data for more than 25000 organizations, six lines per company, with repeated fields as shown below:
City ST Zip
I need to get this data into CSV format (to be imported as "Accounts" inside Outlook 2007 BCM), one record per line. While I can see how to do this programmatically using VB or possibly some scripting language, I'm wondering if there isn't an even easier way to do what I want using either a standalone utility or perhaps some import capability possessed by one of the Office apps (Excel, Access, etc...). Suggestions?
** NOTE **
Just to make things challenging, the fourth (4th) line of each record (City State ZIP) is not comma-delimited - the original author simply used spaces <grrr>. I point this out as obviously there are city names (e.g. "New York City") having embedded spaces. Conversely, many of the records contain street addresses (3rd line) having embedded commas <double grrr>.