Hi Hive brain,

I have a string field that can be a number of values separated by a comma e.g

CAT, DOG, HORSE
CAT, HORSE
HORSE
HORSE, DOG, HAMSTER
I may also have a Null value here

What I would like to do is count the number of values e.g

CAT, DOG, HORSE = 3
CAT, HORSE = 2
HORSE = 1
HORSE, DOG, HAMSTER = 3
I may also have a Null value here = 0

Thats all I need, I don't really need an array of the values, I just need to know how many values there are. I've started down the "Split" function route but I can't seem to get what I want, is there an easier way?

Create a formula using this code (crystal syntax):

If Isnull({Table.StringField}) Then 0 Else Ubound(split({Table.StringField}, ","))