adding dashes to a ssn

hi guys!

I’m trying to add dashes to social security numbers but i don’t know how. I’ve used a rule engine to create “–” as a response to a null/missing entry but if a ssn is 123456789 i want it 123-45-6789

My googlefu is weak :frowning:

Use a String Manipulation node.

4 Likes

Hi @isdadmin and welcome to the community forum,

In addition to the solution by @quaeler, you could also use regex in the String Manipulation node for this. e.g.:

regexReplace($column1$, "(.{3})(.{2})(.+)", "$1-$2-$3")

:blush:

4 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.