Quick count list items in a string separated by commas

[JGalletta]

Guys,

Can someone post code for counting commas/specific chars in a string?

i.e.

String = " A,B,C,D "

CountCommas(String) would return 3..

?

My brain is beat for the day..

 

[pbaldy]

One way:

?Len(" A,B,C,D ")-Len(replace(" A,B,C,D ",",",""))
3

 

[JGalletta]

That's creative. I like that. Thanks.

 

[pbaldy]

No problem. That's quick and dirty. You could also create a function to step through the characters, or use the Split() function.