>>I want to extract the string between the asterisks, or between an asterisk and the tilde if it's the last occurrence. If I use StrExtract() with occurrences from 1 to 4, I get "4" "3" "23" and "0" as results in the example below.
>>
>>
>>m.test = "HL*4*3*23*0~"
>>
>>
>>This evaluates to "" because there is no second asterisk for the fourth occurrence:
>>
>>m.String = STREXTRACT(m.test, "*", "*", 4)
>>
>
>Why don't you just use ALINES() with the parse character parameter to break the whole thing up at once?
>
>Tamar
Thanks, but I'm not trying to break the whole thing up at once.