Update SSN Filed

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • jpr

    Update SSN Filed

    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

    #2
    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


    Comment

    • Ron2006

      #3
      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

      Comment

      Working...