Quote Originally Posted by p45cal View Post
try:
FieldInfo:=Array(Array(0, 1), Array(33, 1), Array(57, 1))
you might need to fine tune the numbers a bit.
The first number in each pair is the zero-based postion of the start of the column, and they need to be ascending. The second number of each pair is the data type/format (General in this case).
In the above example
column1 will be characters 0 to 32 (that's 33 characters in all)
column2 will be characters 33 to 56 (that's 24 characters)
column3 will be characters 57 to the end (as many characters as are left in the source string).

If you want the 3rd column to be limited to 24 characters then add another pair:
FieldInfo:=Array(Array(0, 1), Array(33, 1), Array(57, 1), Array(81, 9))
which will skip all characters from 81 to the end of the source string.
Yes, that was my issue. I miss understood the array parameter.

Go raihb maith agat!