Data Type Validation Patterns

The following Cloud Dataprep data types utilize regular expressions to validate data against the type. For other data types, validation is performed without using regular expressions.

For a list of Cloud Dataprep data types, see Supported Data Types.

Patterns matching the following regular expressions are considered valid for the listed data type.

Credit Card

^4\\d{3}[ -]?(\\d{4}[ -]?){3}$
^5[1-5]\\d{2}[ -]?(\\d{4}[ -]?){3}$
^3[4,7]\\d{2}[ -]?\\d{6}[ -]?\\d{5}$
^6(011|(5\\d{2}))[ -]?(\\d{4}[ -]?){3}$
^((35\\d{2}[ -]?(\\d{4}[ -]?){3})|((1800|2131)[ -]?(\\d{4}[ -]?){2}\\d{3}))$
^3((0[0-5]\\d{1})|([6,8]\\d{2}))[ -]?\\d{6}[ -]?\\d{5}$

Email Address

^[a-z0-9.!#$%&'*+/=?^_`{|}~-]+@[a-z0-9.-]+(?:\\.[a-z0-9-]+)*\\.[a-z]{2,}$

Gender

^(m(?:ale)?|f(?:emale)?)$

Phone Number

^(?:(?:\\+?1\\s*(?:[\\.-]\\s*)?)?(?:\\(\\s*(?:[2-9]1[02-9]|[2-9][02-8][0-9])\\s*\\)|(?:[2-9]1[02-9]|[2-9][02-8]1|[2-9][02-8][02-9]))\\s*(?:[.-]\\s*)?)(?:[2-9]1[02-9]|[2-9][02-9]1|[2-9][02-9]{2})\\s*(?:[.-]\\s*)?(?:[0-9]{4})(?:\\s*(?:#|x\\.?|ext\\.?|extension)\\s*(?:\\d+))?$

Social Security Number

^(00[1-9]|0[1-9]\\d|66[0-57-9]|6[0-57-9]\\d|[1-57-8]\\d{2})([ -]?)(0[1-9]|[1-9]\\d)\\2(000[1-9]|00[1-9]\\d|0[1-9]\\d{2}|[1-9]\\d{3})$

Zip Code

^([\\d]{5}|[\\d]{9})$
^[\\d]{5}-[\\d]{4}