Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

RegeX for telephone numbers

Highlighted
8 - Asteroid

Hi,

 

I have the below list of telephone numbers to be validated - the string is allowed to contain spaces or + or () but no alphabets.

 

Please can you suggest how to get it done.

 

Phone#Result
A123Invalid
1234567Valid
1234 5678Valid
+12345Valid
(0) 1234Valid
3456HInvalid
123-456Valid

 

Thanks

Meena

Alteryx
Alteryx

hi @Meena ,

 

you can use the data cleansing tool and select to remove letters.

 

 

bpatel_1-1574802560468.png

 

hope this helps!

Highlighted
8 - Asteroid

Solved .. using !(REGEX_Match([Value],'[\d|(|)|+|\s|-]+'))

Labels