Number of Occurences in a String 1

[mwake]

I'm using CR 2008 and Oracle 10G as a database. I have a Selected Countries field that is a string that contains multiple country id's separated by commas (ex. 12, 125, 187, 94). I need to create a formula which gives me the total number of countries in the string. Given the 12, 125, 187, 94 example, the formula would return the number 4. How do I do it??

 

[briangriffin]

Give this a try:

whileprintingrecords;
stringvar array v_countries := split({yourfield},",");
ubound(v_countries)

 

[mwake]

Thanks Brian. That did the trick!!