IS_PHONE_NUMBER

Description

Returns TRUE if the provided string matches a valid phone number format; otherwise, returns FALSE.

Syntax

IS_PHONE_NUMBER(string) -> Boolean

Parameters

ParameterData TypeRequiredDescription
stringStringYesThe string to evaluate.

Examples

IS_PHONE_NUMBER("123-456-7890")
-- Returns TRUE.
IS_PHONE_NUMBER("+1 (123) 456-7890 ext.1234")
-- Returns TRUE.

Tips

  • Returns FALSE if the string is empty.

  • Accepted formats:

    • Optional "+" and country code (e.g., "+1")

    • Optional parentheses around area codes

    • Digits separated by spaces, hyphens, or dots

    • Optional extensions prefixed with "x" or "ext."

  • Regex Used:

    ^(\\+?1[-. ]?)?(\\(\\d{3}\\)|\\d{3})?[-. ]?\\d{3}[-. ]?\\d{4}(?:[ ]?(?:x|ext\\.?)[ ]?\\d{1,5})?$|^(\\+?\\d{1,3})?[-. ]?(\\(\\d{1,4}\\)|\\d{1,4})?[-. ]?\\d{1,4}[-. ]?\\d{1,4}[-. ]?\\d{1,9}(?:[ ]?(?:x|ext\\.?)[ ]?\\d{1,5})?$