Good day;
I have been banging my head against the wall on this problem for a while
and am hoping someone out there may have a resource (web site, book, etc)
that can help me figure this puppy out...
I have been given a couple text files that looks like it pulled names,
addresses and phone numbers from a website. I have been asked to extract
the data so that the information can be manipulated into reports or placed
in a phone directory.
The problem is: there is no consistency in how the data is stored in these
files: There may be a record number, a bunch of spaces, then address, city,
state, zip. The following record may have the company name, zip, a bunch of
spaces, state, address,... (you get the picture). The phone/fax information
is in another file altogether.
My first thought was to use a hash based on a record number, but I'm not
sure how I'd marry that up with the remaining information for each record.
I don't like to think that anything is impossible, that's why I'm hoping
someone has a recommendation for how I should tackle this problem.
Thanks in advance for any/all help. I can send snippets of the text files
(complete files range in size from 25-66MB) off line if desired.
Sincerely,
Carl
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
