I have a long TXT type document with a column-like layout which I need to
load into Word, go throughout it, strip the spaces between the columns and
replace them with tab-stops. The end-of-the-line breaks of paragraphs
(hard-ones, I believe) need to remain that way so they're not an issue.
Since the data in columns is words which does contain spaces between each
word, obviously you would NOT want to replace THOSE spaces with tab
stops--only the multiple spaces between each column.
By the way, there is NOT the same amount of spaces between each column
either.
I would imagine this would require some Visual Basic. I have quite a bit of
fluency in that with regards to Access, far less so with Word, Excel etc.
Tips?
Seems though Excel converts it cleaner, so if somehow Excel could do it but
then keep tabs between the columns yet carriage-returns at the end of the
line that may work. Don't know.
Again, tips?
LRH
Greg Maxey - 09 Mar 2004 20:18 GMT
Larry,
Have you tried Edit>Replace>More>Use Wildcards
Type"
{2,} in the find what field (that is a space before the
leading {
and
^t in the replace with field
>-----Original Message-----
>I have a long TXT type document with a column-like layout which I need to
[quoted text clipped - 23 lines]
>
>.
Brandon - 09 Mar 2004 20:25 GMT
Just an idea:
Determine the smallest number of spaces between columns.
then do a global F/R, and replace it with a tab stop.
Then do multiple runs of F/R, replacing each instance of
^t[space] with ^t.
Brandon
>-----Original Message-----
>I have a long TXT type document with a column-like layout which I need to
[quoted text clipped - 23 lines]
>
>.