AnsweredAssumed Answered

Remove Non-Numeric Text

Question asked by JoshuaGagnon on Oct 21, 2014
Latest reply on Oct 21, 2014 by raybaudi

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!

Outcomes