Removing Unwanted Character

[hprice]

I've discovered some phone numbers in our database with unwanted characters included. Wondering the best way to remove these characters. Sample of what I'm seeing is included in the post.

[MilindG]

@hprice You can use Data cleansing tool. Please see the attached workflow

[hprice]

Unfortunately I have already tried the data cleanse tool and it doesn't remove these particular characters. I should add this is a string, not numeric value.

[Luqman]

Formula tool

REGEX_Replace([your collumn], "[\D]", "")

It uses regex to replace anything that is not a digit with a blank string.

[MarqueeCrew · Accepted solution]

@hprice 

RegEx can identify anything not a decimal "\d" with "\D".

REGEX_Replace([stuff], "\D", '')

This will get rid of stuff not in {0,1,2,3,4,5,6,7,8,9}

Cheers,

Mark