exclude non-numeric characters (or special characters) from telephone numbers with the use of regex

[claudia80]

Good morning.
I would like to improve a regex expression to make sure that the mobile number is recognized even if there are non-numeric characters between the digits such as:. - etc.
I read that you have to enter \ D or \ W but it doesn't work.
Can you help me?

(\((00|\+)39\)|(00|\+)39)?(39[0-37-9]|38[02-589]|34[0-9]|36[0-3680]|33[13-90]|32[2347890]|35[0-35]|37[0-9])(\s?\d{3}\s?\d{3,4}|\d{6,7})

regex expression valid for all numbers listed except for numbers with the addition of characters to exclude with the new version:

site for checking regex expression:

RegExr: Learn, Build, & Test RegEx RegExr is an online tool to learn, build, & test Regular Expressions (RegEx / RegExp). regexr.com

regex101: build, test, and debug regex Regular expression tester with syntax highlighting, explanation, cheat sheet for PHP/PCRE, Python, GO, JavaScript, Java, C#/.NET, Rust. regex101.com

list of numbers:

320123456
3201234567
320 123456
320 1234567
320 123 456
320 123 4567
39320123456
393201234567
39 320123456
39 320 123456
39 320 123 456
39 320 123456
39 320 123 456
39320123456
393201234567
+39 320123456
+39 320 123456
+39 320 123 456
+39 320 123456
+39 320 123 456
39320123456
393201234567
0039 320123456
0039 320 123456
0039 320 123 456
0039 320 123456
0039 320 123 456
(+39) 320123456
(+39) 3201234567
(+39) 320123456
(+39) 320 123456
(+39) 320 123 456
(+39) 320 123456
(+39) 320 123 456
(0039) 320123456
(0039) 3201234567
(0039) 320123456
(0039) 320 123456
(0039) 320 123 456
(0039) 320 123456
(0039) 320 123 456

 

[sandy666]

with Power Query
is that what you want to achieve?

list of numbers:	Numbers
320123456	320123456
3201234567	3201234567
320 123456	320123456
320 1234567	3201234567
320 123 456	320123456
320 123 4567	3201234567
39320123456	39320123456
393201234567	393201234567
39 320123456	39320123456
39 320 123456	39320123456
39 320 123 456	39320123456
39 320 123456	39320123456
39 320 123 456	39320123456
39320123456	39320123456
393201234567	393201234567
+39 320123456	39320123456
+39 320 123456	39320123456
+39 320 123 456	39320123456
+39 320 123456	39320123456
+39 320 123 456	39320123456
39320123456	39320123456
393201234567	393201234567
0039 320123456	0039320123456
0039 320 123456	0039320123456
0039 320 123 456	0039320123456
0039 320 123456	0039320123456
0039 320 123 456	0039320123456
(+39) 320123456	39320123456
(+39) 3201234567	393201234567
(+39) 320123456	39320123456
(+39) 320 123456	39320123456
(+39) 320 123 456	39320123456
(+39) 320 123456	39320123456
(+39) 320 123 456	39320123456
(0039) 320123456	0039320123456
(0039) 3201234567	00393201234567
(0039) 320123456	0039320123456
(0039) 320 123456	0039320123456
(0039) 320 123 456	0039320123456
(0039) 320 123456	0039320123456
(0039) 320 123 456	0039320123456

 

[claudia80]

No.
I have a macro that extracts mobile phone numbers from websites.
If there is a number on a website that contains a symbol such as:. /
does not extract it.
So I would need to improve the regex expression so that the macro also recognizes the numbers that have those symbols inside them.
these symbols can be added to the list of numbers I entered earlier on the regex expression verification website.
The regegex expression should consider numbers not taking symbols into account

 

[claudia80]

320.123.456

320/1234567 etc

 

[sandy666]

you can define what you want to extract: Text.Select([#"list of numbers:"],{"0".."9","/","+"})
but I don't want to bother with regex in vba
good luck

 

[claudia80]

Thank you.
I hope there is someone who knows how to fix it.