>>
>
>yourstring="123,456,abc"
>STREXTRACT( yourstring, ",", "", 3)
>
>>will extract "abc", the last field, in the above example
>Sorry, I left out the occurance number, "3". Using my eye as a compiler has it's limits.
Yes, I sensed a typo somewhere in your message.
> Yes, you could say this is special case handling for the first and last fields. In the case of the last field you have to know how many fields there are.
With the array approach we don't have to know in advance how many elements are in the strings and we can loop through them without having to worry about that (with
ALEN() function or
FOR EACH construct). And one can even easily check if both strings have the same number of elements (don't know if this should add to the original problem's requisits).
----------------------------------
António Tavares Lopes