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