Count Number in a string

[SuperTime]

Crystal 9, Sql database



I have a String field in the database

38870,38891,38894,38898,39037,39044,


I want read this field and count the numbers in the string . so i want to get the number 6 in the above example.

How can i do that in a formula

 

[Turkbear]

Hi,
If the string is always separated by commas, then create an array and check # of entries:
This should do it:
@howmany

UBound(Split({YOURSTRINGFIELD},','))

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Since the last number in your example has a comma after it, you'll need to subtract one.

UBound(Split({YOURSTRINGFIELD},','))-1

-k

 

[Turkbear]

Hi,
Nice catch, synapse - and on a Friday afternoon as well..I'm impressed....



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Probably a typo anyway, Turk, just thought I'd mention it.

-k