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
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
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
6 people are following this question.