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
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
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")
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.