How do you remove the hyphen in social sec nbrs? 3

[NewToThis2]

C V9 - could someone please tell me the formula to use to remove the hyphen in a social security number? For example, I want 254-98-8889 to read 254988889. Thanks!

 

[pbateman]

The formula below will remove all none numeric values (including hyphens):

stringVar strSocialNumber := "254-98-8889";
numberVar i;
stringVar strOutput;

for i:= 1 to len(strSocialNumber) do
(

if isnumeric(strSocialNumber) then
strOutput := strOutput & strSocialNumber
else
strOutput;

);

strOutput;

 

[vidru]

Or to simplify a bit:

Replace({Table.Field},"-","")

-dave

 

[NewToThis2]

Thanks so much everyone! The simplified formula worked best and quickest for me. I was in the middle of a report that needed to go out this morning and I couldn't remember how to remove the dashes. Thanks again for everyone's quick response!