Update SSN Filed

[jpr]

Hello,

I have a field with a text property used to store SSN. It has this
format: 123-45-6789

Is there a way I can update the field to show 123456789. I would like
to remove the dashes. Thank you.

[Jens Schilling]

Re: Update SSN Filed

Hi,

I have a field with a text property used to store SSN. It has this
format: 123-45-6789
>
Is there a way I can update the field to show 123456789. I would like
to remove the dashes. Thank you.

Try : replace("123-45-6789","-","")

Regards
Jens

[Ron2006]

Re: Update SSN Filed

It will also depend on whether there is a format for the field. Are
people actually entering the "-" or do they appear automatically.

If they appear automatically when you start to enter a number then open
the form in developer mode and select properties of that field.
On the Data Tab
delete the input mask.

Ron