question

ewinkiser avatar image
0 Votes"
ewinkiser asked NandanHegde-7720 edited

How do remove hyphens in Social Security Number?

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

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered NandanHegde-7720 edited

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://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#replace

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.