Cleanup Mobile Phone Numbers using SQL and Automation Studio

REPLACE(TRANSLATE(PersonMobilePhone, 'abcdefghijklmnopqrstuvwxyz+()- ,#+', '@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@'), '@', '')

Full Code

--

--

--

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Adding accelerometer support to KoReader for Kindle Touch: Part 1

How you can accelerate knowledge-transfer with MOB-programming

Is Control Better than Speed for your ColdFusion Apps?

Lambda Function URLs are now available on AWS

Auto-binding and its use

My First Project At FlatIron School

How to Integrate your Selenium Project with Jenkins

Software Development Life Cycle

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Charlie Fay

Charlie Fay

I am a certified Salesforce Marketing Cloud Consultant at Bower House Digital in Melbourne, Australia.

More from Medium

SQL Server DROP and CREATE

Git 101 (for dummies)

SQL Server Procedure Multi Statement as Bit Wisely

SQL Server — Do my query use forced plans from Query Store?