Question

How to Remove Dashes from a Social Security Number?

Workflow

Updated September 28, 2015

asked on September 28, 2015

I'm feeling a little out of it today and for some reason cannot remember how to remove the dashes in a social security number using Workflow. I'm pretty sure I should be using Pattern Matching, but cannot figure out the pattern to use. Would someone mind helping me please?

2 0

Answer

SELECTED ANSWER

replied on September 28, 2015

It works for me...

1 0

Replies

replied on September 28, 2015

([^\-]+) - anything but a dash (with the \ escape character since the dash is a reserved character. Set it to "all matches combined with no spaces".

2 0

replied on September 28, 2015

Thank you Miruna. That brought back the first two sets, but the last 4 digits are not coming back. So for 000-00-0000, it brought back 00000. Any ideas?

1 0

SELECTED ANSWER

replied on September 28, 2015

It works for me...

1 0

replied on September 28, 2015

My bad, I added the dash after the last parenthesis. That works. Thank you!

1 0

replied on September 28, 2015

May not be the best way but I always get the numbers on their own and piece them back together.

First Part - (\d\d\d)\-\d\d\-\d\d\d\d

Second Part - \d\d\d\-(\d\d)\-\d\d\d\d

Third - \d\d\d\-\d\d\-(\d\d\d\d)

0 0

You are not allowed to follow up in this post.

Question

Question

How to Remove Dashes from a Social Security Number?

Answer

Replies

Sign in to reply to this post.