Remove Non-Numeric Text
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!
The meaning of that row is:
Create a calculation field, named FilteredTextCalc, result type: text with calc:
Filter ( SSN ; "0123456789" )