|
-
Jan 4th, 2004, 12:10 AM
#1
Thread Starter
Member
Changing Text file to Access/Excel/Word Format
I have a problem. Can you convert the file to only a list in Access/Excel/Word
now the format is like this
anchovy images\a\a00.gif1261.gif ancient images\a\a00.gif1262.gif anciently images\a\a00.gif1263.gif ancillary images\a\a00.gif1264.gif and images\a\a00.gif1265.gif anecdotal images\a\a00.gif1266.gif
and i want it like this:-
anchovy images\a\a00.gif1261.gif
ancient images\a\a00.gif1262.gif
anciently images\a\a00.gif1263.gif
ancillary images\a\a00.gif1264.gif
and images\a\a00.gif1265.gif
anecdotal images\a\a00.gif1266.gif
Please send me a code or any way you can tell me
Thanks
-
Jan 4th, 2004, 06:40 AM
#2
Fanatic Member
Just read in the existing file, insert a vbCRLF after every second space you find, and write it out to a new file
Do canibals not eat clowns because they taste funny? 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|