Count Occurence 1

[eebabe]

Hello:

Environment: CRX

field1: PC 647(F) PC 647F,647F,647F,647F,647F CONDITI ;PC 148(A) 30/10

would like to count how many times the variation of PC 647(F) or 647F or 647(F)occurs in this field. I tried instr function but only gives me the first occurence.

Thanks.

 

[lbass]

stringvar x := {table.string};
stringvar y := replace(replace(x,"(",""),")","");
numbervar i;
numbervar j := len;
numbervar cnt := 0;
for i := 1 to j do(
if y+y[i+1]+y[i+2]+y[i+3] = "647F" then
cnt := cnt + 1
);
cnt;

-LB

 

[eebabe]

Thanks LB. Worked like a charm. You ROCK!!