SSIS Cleanse phone number

Question

Hello,

I have a SSIS report that imports excel files into SQL database. Sometimes users put these characters in the Phone number columns -, 9, 0, +

Can someone help me remove these in SSIS workflow. I'm hoping there is some type of find and replace where I can replace characters with blank.

Any help would be greatly appreciated.

Thanks,

Tim

Answer 1

In derived column transformation, you could use expression like this

REPLACE(REPLACE(REPLACE( REPLACE( [ColumnName] , "(", "") , "-", ""), ")", ""), " ", "")

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav