remove "-" from SSN

[sericson]

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 solution]

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 solution]

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

[sericson]

thank you both!!