View Single Post
  #1   Report Post  
Salty
 
Posts: n/a
Default Unusual data format

I am hoping someone has done this before.

I have a client who has been presented with several thousand records in
an unusual format. Each is formatted thus:

Name<CR
Agency<CR
Address<CR
CityStateZip (all in one field)
<CR
Phone<CR
Email<CR
<CR
Name<CR
Agency<CR
Address<CR
CityStateZip<CR
Phone<CR
Email<CR
<CR

and so on.

She wants to be able have a standard data file, Excel or CSV to use in
a database. Has anyone seen an automayted method to move these around
without having someone sit and do it manually for several days.

salty