1 Reply Latest reply on Oct 21, 2014 10:18 AM by raybaudi

    Remove Non-Numeric Text

    JoshuaGagnon

      Title

      Remove Non-Numeric Text

      Post

      Hello,

      I am running a report where they are requesting that the SSN does not have the dashes (numeric only). So, I setup a validation where anytime a new SSN is entered it gives an error if it has any non-numeric characters. However, I am looking for a way to remove them from existing fields.

      I did a quick search and found this formula, however I am getting an error that "FilteredTextCalc" is not recognized: 

      FilteredTextCalc (text) = Filter ( SSN ; "0123456789" )

      Is there an easy way to remove non numeric text from existing fields?

      Thanks in advance!