SOLVED
Removing Unwanted Character
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hprice
6 - Meteoroid
‎11-09-2023
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Parse
4 REPLIES 4
MilindG
12 - Quasar
‎11-09-2023
09:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@hprice You can use Data cleansing tool. Please see the attached workflow
‎11-09-2023
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
7 - Meteor
‎11-09-2023
09:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Formula tool
REGEX_Replace([your collumn], "[\D]", "")
It uses regex to replace anything that is not a digit with a blank string.
20 - Arcturus
‎11-09-2023
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
