forum.vdsworld.com

[Capinha]

Hello there,

I have several large sized number matrix with columns separated by whitespace, and I'm trying to transform the whitespace in a carriage return, so that all values converge in one column.

Something like:

from this:
123 122 133 122
122 111 111 222
...

to this:
123
122
133
122
122
111
111
222
...

I've tried to use this expression using string.dll extension

%b = @string(RegxRepInFile,c:\file.txt,c:\output.txtt," ",@cr(),)

and also:

%b = @string(RegxRepInFile,c:\file.txt,c:\output.txtt," ",(\r),)

but the first returns a rectangular symbol in place of the whitespace and the other just inserts the "r" character...

The optional use of repeat or if sentences instead revealed to be very very time consuming...

any sugestions?


Cheers

César

[ShinobiSoft]

Try this::