RegeX for telephone numbers

[Meena]

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
A123	Invalid
1234567	Valid
1234 5678	Valid
+12345	Valid
(0) 1234	Valid
3456H	Invalid
123-456	Valid

Thanks

Meena

[bpatel]

hi @Meena ,

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

hope this helps!

[Meena · Accepted solution]

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