babs
Can't get enough of FH
- Joined
- Dec 30, 2003
- Messages
- 1,595
I have a series of large text files holding details about organisations and businesses (they're basically search dumps from a website) which I want to parse into a spreadsheet ideally (database at a push). When saved as a text file each record on the page appears like this..
Every record is essentially the same, but some do not have a contact name, and some don't have an email address etc.
Is there a semi-easy way to parse this information into a spreadsheet, using column headers such as company, contact, address, etc.? I imagine we're talking some form of macro/scripting, but as familiar as I am with Excel I've never got into that side of things.
Any ideas then to save me from inane googling and headaches? My best thought so far was to use a find/replace to replace the ------------ with a carriage return, and read it in as a text file using * as a delimiter and then do some manual tidying
Code:
*ACNE SUPPORT GROUP* *Address: *P.O.Box 9, NEWQUAY, TR9 6WG. *Tel: *08708 xxxxxx. *Email: *xxxxxxxx@btopenworld.com. *Website: *www.stopspots.org. *LAST UPDATED:* 16/01/2007 ------------------------------------------------------------------------
Every record is essentially the same, but some do not have a contact name, and some don't have an email address etc.
Is there a semi-easy way to parse this information into a spreadsheet, using column headers such as company, contact, address, etc.? I imagine we're talking some form of macro/scripting, but as familiar as I am with Excel I've never got into that side of things.
Any ideas then to save me from inane googling and headaches? My best thought so far was to use a find/replace to replace the ------------ with a carriage return, and read it in as a text file using * as a delimiter and then do some manual tidying