text file extraction

[6878]

Hi,

How to extract file if there more space between colums. ( 2 SPACE 2 AND 3 COLUMN AND 6 SPACE BETWEEN 3 AND 4TH)

for eg. 171.011110 1  41A             Rx   d 8 00 00 07 00 00 00 00 00 TE
          171.100900 1  3E1             Rx   d 8 C0 00 00 00 00 00 80 00 TE

TKS

[F._Schubert · Accepted solution]

Most likely, your file format is of fixed width. So get your data as an 2D array of strings by splitting the string at fixed indices. Then use the Trim whitespace function to get rid of the spaces.

Felix