Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

This data type is applied to numeric data following common patterns that express telephone numbers.
  • Parentheses are optional around area code values: (###) ###-####
  • Phone numbers may or may not include the 1 at their beginning.
  • Dashes and spaces are optional between groups of numbers.

    NOTE: Spaces within a group of values are not supported and will result in a mismatched data type entry.

Standard Domestic U.S:

###-###-#####
(###)-###-#####
##########
1##########

Standard Domestic U.S. with extensions:

(###)-###-#### x ###
  • The dash in ###-#### is required when extension is present.
  • The extension indicator can be one of the following: xXext, or EXT.

International U.S:

+1(###)-###-####

Not supported:

  • Local U.S. format not supported:

    ###-####
  • International format:

    +##-##-###-#####
  • Internal international format not supported:

    ##-##-##-###-#####

Your Rating: Results: PatheticBadOKGoodOutstanding! 2 rates

This page has no comments.