SSIS Cleanse phone number

Tim Mullady 221 Reputation points
2021-01-04T15:37:47.5+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,587 questions
0 comments No comments
{count} votes

Accepted answer
  1. Vaibhav Chaudhari 38,746 Reputation points
    2021-01-04T15:49:41.353+00:00

    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

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.