My problem is parsing a text fields string
I'm using Split() to generate an array (based on a space)
I would like to know how to determine the length of the array
as I would like to only return only the last three in the array and catenate them into a field.
i.e. "The cat sat on" = "cat sat on"
    " The cat sat on the mat = "on the mat"

Use UBound(Array) to get the upper bound of the array for your calcs. So:

If the CatArray() was:

0 - The
1 - cat
2 - sat
3 - on
4 - the
5 - mat

I think UBound(CatArray) would return 5. It might return 6. You'll have to mess around with that or someone can chime in.

So,

i = UBound(CatArray) ('pretend i = 5 then)

i = i - 3

Do Until UBound(CatArray) (I remember adding + 1 here)
   myString = myString & " " & CatArray(i)
i = i + 1
Loop


Did that work?



mmcdonal

Sorry, correction:

Do Until i = UBound(CatArray) (I remember adding + 1 here)
   myString = myString & " " & CatArray(i)
i = i + 1
Loop


mmcdonal

Of course, silly me, thanks for the reminder

Actually, will there ever be a situation where there might be less than three items in the array? If so, you would want to check the value of i after you set it to UBound(CatArray) and adjust your code accordingly.



mmcdonal