Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
regexReplace(mobilePhoneColumn,'[^0-9.]','')
RegexMatch in ADF
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 17%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mohamed Mohamed
66
Reputation points
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!
Accepted answer
-
MarkKromer-MSFT 5,206 Reputation points Microsoft Employee2021-12-14T18:50:50.307+00:00 -
Mohamed Mohamed 66 Reputation points
2021-12-16T15:27:45.4+00:00 Thanks @MarkKromer-MSFT - That worked perfectly I believe. Im looking for a way to test that as I just scanned the output i excel and it seems fine.
Im quite sure that there were some spaces and now its cleaned away, so '[^0-9.] this worked perfectly for whitespaces, but i thought this '[^0-9.] would only remove characters that arnt digits - Could you please elaborate more?
Also, can alter that line to remove dots '.' , some fields contains '.' or '..' or '...' ? Thanks!
Sign in to comment -