Page tree



Contents:

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

Contents:


The following Trifacta® 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 Trifacta 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})$


State

^(al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx|ut|vt|va|wa|wv|wi|wy|pr|dc|vi)$ ^(alabama|alaska|arizona|arkansas|california|colorado|connecticut|delaware|florida|georgia|hawaii|idaho|illinois|indiana|iowa|kansas|kentucky|louisiana|maine|maryland|massachusetts|michigan|minnesota|mississippi|missouri|montana|nebraska|nevada|new hampshire|new jersey|new mexico|new york|north carolina|north dakota|ohio|oklahoma|oregon|pennsylvania|rhode island|south carolina|south dakota|tennessee|texas|utah|vermont|virginia|washington|west virginia|wisconsin|wyoming|puerto rico|district of columbia|virgin islands)$

Zip Code

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

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 12 rates

This page has no comments.