Need to save each line as a new file using part of the line as the name. See next:
Here is my current file:
first_name=&last_name=&city=&rowBegins=00001&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00026&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00051&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00076&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00101&reference=/memberdirectory/results.cfm
I want to save the first line into a file all by itself and name it 00001.txt
Then the next line should be in a file all by itself and named 0026.txt and so on, there are 1510 line in theis file, so I am looking for 1510 .txt files when I am done.
All of my attempts at a macro have produced nothing short of a complete mess!
Thanks for some help!
Jason.
Here is my current file:
first_name=&last_name=&city=&rowBegins=00001&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00026&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00051&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00076&reference=/memberdirectory/results.cfm
first_name=&last_name=&city=&rowBegins=00101&reference=/memberdirectory/results.cfm
I want to save the first line into a file all by itself and name it 00001.txt
Then the next line should be in a file all by itself and named 0026.txt and so on, there are 1510 line in theis file, so I am looking for 1510 .txt files when I am done.
All of my attempts at a macro have produced nothing short of a complete mess!
Thanks for some help!
Jason.