remove "-" from SSN

Question

hello! We parse data from excel files that are inconsistent in their formats. I need to be able to remove the dash (-) from SSNs that come over, not all of the files have the dash in them so I need a tool that won't error out if it comes without the dash in it. Thank you!

ShankerV · Accepted Answer

Hi @sericson

Please use the Replace() function, it will not error even if the incoming column SSN does not contain any "-"

Syntax: Replace(String, Target, Replacement)

If you need to remove - ,Replace([Column name], '-', '')

If you need to replace - with space, then Replace([Column name], '-', ' ')

Many thanks

Shanker V

MilindG · Accepted Answer

@sericson Replace([SSN], '-','') should work