Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Trifacta Wrangler Pro


Contents:

Designer Cloud Wrangler Pro is no longer available. Please visit this page instead: Phone Number Data Type

   

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:

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

  • No labels

This page has no comments.