>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)
>
Jay, Use the last argument for strextract to say ending delimiter is not required;
m.String = STREXTRACT(m.test, "*", "*", 4, 2)