08-05-2011 03:58 AM
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
Solved! Go to Solution.
08-05-2011 04:02 AM
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