Do you mean that you actually have a fixed-width format file ?

NickHK

"simonc" wrote in message
...
I am reading lines from a formatted data file (values in right justified
columns) and using split to extract the values from each line into an
array.
The problem is the number of spaces between values is not constant, and
split
adds a new array value for every space it finds in the text string. Is
there
a way to set split to treat consecutive spaces as a single delimiter like
you
can in TextToColumns?