Function validate Number phone

[vvferreira]

Hello Guys,

is there currently any function that can validate the phone number, mobile? 

[Reeza]

Validate as in check that the format is correct, or validate as in check that it's an operational phone number?

[vvferreira]

Hi, @Reeza, 
I would just like to validate if format is correct.

[Reeza · Accepted solution]

A quick google search shows a lot of variation in this topic. 

Please provide some sample input data and expected output to demonstrate your problem. As you can see from the posts above there can be many variations in the source data and we're obviously unfamiliar with your data.

[vvferreira]

Thanks Reeza,

I'm a new member and I'm still getting used to it here 🙂

[ballardw]

Be aware that just a string of digits is insufficient. You need the spaces, dashes or whatever to separate out parts like, in US, Area-code and number.

Found this out with a set of "phone numbers" that had no spaces that included foreign country codes. Treated as US numbers and was dialing Colorado instead of Brazil.