Counting Substrings

[Anonymous]

I'm trying to count how many substrings are there in one string that contains multiple values separated by ";"

For example, if field MultipleValues contain "ab;ac;ad;ef"

I should get 4 back.

I tried doing:

GetSelectedCount(MultipleValues, Subfield(MulitipleValues, ';'))

or

SubStirngCount(MultipleValues, Subfield(MultipleValues, ';'))

but didn't get desired results.

[Anonymous · Accepted solution]

Thanks Miguel but I believe I got it by using:

SubStringCount(MultipleValues, ';') + 1