RegexMatch in ADF

Mohamed Mohamed 66 Reputation points
2021-12-14T16:46:04.887+00:00

In ADF, Ive a MobilePohne column, with +600k rows. How can i make sure its cleaned from 1. whitespaces 2. letters 3.special Character please? I believe i need to use RegexMatch! Thanks!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,149 questions
0 comments No comments
{count} votes

Accepted answer
  1. MarkKromer-MSFT 5,186 Reputation points Microsoft Employee
    2021-12-14T18:50:50.307+00:00

    regexReplace(mobilePhoneColumn,'[^0-9.]','')


0 additional answers

Sort by: Most helpful