Counting digits in a field

[vblack7770]

I am using CR 8.5 with an ODBC to the database. I would like to write a formula that would help me count the digits in the social security # field and return all records that have > or < 9 digits. Thoughts?

 

[lbass]

The following should give you the number of digits in the field, assuming no letters are mistakenly entered:

len(trim(replace({table.ssn},"-","")))

If there might be letters, then use:

stringvar ssn := trim(replace({table.ssn},"-",""));
numbervar i;
numbervar j := len(ssn);
numbervar cnt;

for i := 1 to j do(
if isnumeric(ssn) then
cnt := cnt + 1
);
cnt

-LB