How do remove hyphens in Social Security Number?

Question

HI
@Nasreen Akter @ShaikMaheer-MSFT @MartinJaffer-MSFT @KranthiPakala-MSFT

I have a social Security number in a DB Table xxx-xxx-xxxx. I need to remove the hyphens in the SS# in a pipeline. Any suggestions?

Thanks
Mike Kiser

Answer 1

Hey,

There are multiple ways :
Since the column is in DB, you can use Replace SQL function while querying the data as well.

or

you can use Replace function in dataflows or normal expressions:
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#replace

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions