>I am receiving a value that contains one or more names, each name is separated with a ; (semicolon). If the value only has 1 name, then there is no ; I am planning on using the STREXTRACT() method to separate the values, but I need to know how many semicolons there are to setup my loop. I know I could do a loop to go through each character in the value, and count that way, but I didn't know if there is a method to get the that count.
>
>
>lcNames=[NAMEONE;NAMETWO]
>or
>lcNames=[NAMEONE]
>
>Thanks
>
>Kirk
Instead of StrExtract(), I suggest you use GetWordNum().
For x=1 to occur(lcString,';')
? 'Name no.' + transform(x) + ' is '+GetWordNum(lcString,x,';')
Endfor