Deleting spaces and inserting a comma into it
Posted on 2001-06-13
Hiya Experts, hope you can help!!
I have many text files that look something like this:
BLOGGS JOE 122334 DINMORE LONDON
JONES FRED 122234 TERRACE BLACKPOOL
These files have thousands of lines in them of similar text, what I want to do is delete all spaces greater than 2 spaces and replace it with a comma (I assume this will make it a CSV file).
Is there any way that I can do this with code. I would be using Access 97 to write the code in.
Hope this is enough information