Page tree

Trifacta Dataprep


Contents:

On April 28, 2021, Google is changing the required permissions for attaching IAM roles to service accounts. If you are using IAM roles for your Google service accounts, please see Changes to User Management.

   

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:

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

This page has no comments.