Count Occurances

[Smithsc]

Hi,
Is there a formula that can count the number of occurances of a certain charachter in a string. I need to add this into a formula field. I'm using CR XI

Thanks

 

[CoSpringsGuy]

manipulate this formula to meet your needs

numbervar a := len({@text1});
numbervar b;
numbervar counter;
stringvar c := "a"; // character looking for
for b := 1 to a Do
(
if mid({@text1},b,1) = c then counter := counter +1
);
counter


_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[Smithsc]

Many Thanks CoSpringsGuy