Indexes and regex categories used in the Semantic-aware analysis

EnrichVersion
6.4
6.3
6.2
6.1
6.0
5.6
EnrichProdName
Talend Big Data Platform
Talend Real-Time Big Data Platform
Talend Data Fabric
Talend Data Services Platform
Talend Data Management Platform
Talend MDM Platform
task
Data Quality and Preparation > Profiling data
EnrichPlatform
Talend Studio

List of the indexes and regex categories used in the Semantic-aware analysis

The Semantic-aware approach analyzes column content based on a set of methods: regex, data dictionary and keyword dictionary.

The dictionary indexes and regex categories are embedded in Talend Studio and used in the Semantic-aware analysis to:
  • help exploring semantic categories of data; and
  • decide what category the data falls in.

If you do not use the latest version of Talend Studio, some of the listed regex categories and data dictionary indexes might not be available.

Regex categories

Regex categories

Description

AT VAT Number

Austrian VAT number

AmEx Credit Card

American Express Card

Bank Routing Transit Number

Bank routing transit number

BE Postal Code

Belgian postal code

BG VAT Number

Bulgarian VAT number

Color Hex Code

Color hexadecimal code

Data URL

URL starting with the word data

DE Phone

German phone number

DE Postal Code

German postal code

EN Month

Month in English

En Month Abbrev

English month abbreviation

EN Weekday

Week day or their abbreviation

Email

Email address

File URL

File URL

FR Insee Code

French Insee code of cities with Corsica and colonies

FR Phone

French phone number

FR Postal Code

French postal code

FR Social Security Number

French social security number

FR VAT Number

French VAT number

Geographic Coordinate

Geographic coordinate, longitude or latitude coordinates with at least meter precision

Geographic Coordinates

Geographic coordinates, Google Maps style GPS Decimal format

Geographic Coordinate (degree)

Geographic coordinates (degrees), latitude and longitude coordinates separated by a comma in the form: N 0:59:59.99,E 0:59:59.99

HDFS URL

HDFS URL

IBAN

International Bank Account Number

IPv4 Address

IPv4 Address

IPv6 Address

IPv6 Address

ISBN-10

International standard book number 10 digits

ISBN-13

International standard book number 13 digits

MAC Address

MAC Address

Mailto URL

Mailto URL

MasterCard Credit Card

MasterCard Credit Card

Money Amount (EN)

Amount of money in English format

Money Amount (FR)

Amount of money in French format

Passport

Passport number

SE Social Security Number

Swedish person number

SEDOL

Stock Exchange Daily Official List

UK Phone

UK phone number

UK Postal Code

UK postal code

UK Social Security Number

National identification number, national identity number, or national insurance number generally called NI number

URL

Web site URL

US Phone

US phone number

US Postal Code

US postal code

US Social Security Number

US social security number

US State

US state

US State Code

US state code

Visa Credit Card

Visa credit card

Web Domain

Web site domain

Data dictionary indexes

Data dictionary indexes

Description

Origin of data

Airport

Airport

Talend

Airport Code

Airport Code

Talend

Animal

Animal

Talend

Answer

Answers with the value Yes or No in different languages

Talend

Beverage

Beverage

YAGO

CA Province Territory

Canadian province

http://www.statoids.com/

CA Province Territory Code

Canadian province code

http://www.statoids.com/

City

City name

Talend

Civility

Civility

Talend

Company

Company name

YAGO

Continent

Company name

Talend

Continent Code

Continent code

Talend

Country

Country name

http://data.okfn.org (Public Domain Dedication and License)

Country Code ISO2

2-letter country code

http://data.okfn.org (Public Domain Dedication and License)

Country Code ISO3

3-letter country code

http://data.okfn.org (Public Domain Dedication and License)

Currency Code

Currency code

http://data.okfn.org (Public Domain Dedication and License)

Currency Name

Currency name

http://data.okfn.org (Public Domain Dedication and License)

First Name

First name

Talend

FR Commune

French municipality

Insee

FR Departement

French department

Insee

FR Region

French region

Insee

FR Region Legacy

Former French region

Insee

Gender

Gender

Talend

HR Department

HR department

Talend

Industry

Industry name

Talend

Industry Group

Industry group

Talend

Job Title

Job title

Talend

Language

Language

Wikipedia

Language Code ISO2

2-letter language code

Wikipedia

Language Code ISO3

3-letter language code

Wikipedia

Last Name

Last name

United States Census Bureau

Measure Unit

Measure unit

Talend

Month

Month

Talend

Museum

Museum name

YAGO

MX Estado

Mexican state

http://www.statoids.com/

MX Estado Code

Mexican state code

http://www.statoids.com/

Organization

Organization

YAGO

Sector

Sector

Talend

Street Type

Street type

Talend

US County

US county name

Wikipedia

US State

US states

Talend

US State Code

US state code

Talend

Weekday

Day of the week

Talend

Keyword dictionary indexes

Keyword dictionary indexes

Description

Origin of data

Address Line

Street number and name

Talend

Full Name

Full name

Talend