Count character in a string

[crystaldev1]

I'm using CR 9. Is there way to count a specific charcter in a string? For ex, I would like to count the number of X's in a string. Thanks.

 

[lbass]

Use a formula like this:

whileprintingrecords;
stringvar x := {Table.string};
numbervar i;
numbervar j := len({table.string});
numbervar y := 0;
for i := 1 to j do(
if ucase(x) = "X" then
y := y + 1
);
y

-LB