How do I find social security numbers in data and replace them with any "Text"

Question

We receives internal company data and we want to do analysis on those data sets, But the problem here is at time the input data we are suppose to utilise has Social Security Number of employee. We want to include a tool in our workflow in order to avoid using any kind of SSN in our data output. So we want to replace the SSN with "None".

The expected data format is like : 12-2345-6789 or 12/345/6789.

Please suggest any formula for this one.

MarqueeCrew · Accepted Answer

The format replacement might be:

regex_replace([field],"\d{2,3}[-/]?\d{2,4}[-/]?\d{4}",'Tax ID Removed')

this will replace 2-3 numbers followed by 0 or 1 delimiters followed by 2-4 numbers followed by 0-1 delimiters followed by 4 numbers with the supplied text.