Field Content

Identification Analysis Definition

The Field Content identification analysis definition supports identification of global and locale specific data. The table below describes those elements that are specific to this locale. For a description of elements that are common across all locales, see the Field Content Identification Analysis Definition section in the Identification Analysis Definitions documentation.

Field Content
Description

The Field Content identification analysis definition identifies the type of data that is represented by a string.
Possible Output

CITY
CITY-STATE/PROVINCE-POSTAL CODE
COUNTRY
CURRENCY
DATE
DATE/TIME
DELIVERY ADDRESS
DEPARTMENT
E-MAIL
EMPTY
FAMILY NAME
FULL ADDRESS
GEOGRAPHICAL POINT
GIVEN NAME
IBAN
INDIVIDUAL
MONTH
NETWORK ADDRESS
ORGANIZATION
PAYMENT CARD NUMBER
PHONE
POSTAL CODE
REGION
SOCIAL SECURITY NUMBER
UNKNOWN
URL
VEHICLE REGISTRATION
Default Identity UNKNOWN
Examples Input Output
M. DuBois INDIVIDUAL
PIERRE RENOIR, SR INDIVIDUAL
R BASQUE INDIVIDUAL
J P CAPET INDIVIDUAL
RENE DESQUESNES INDIVIDUAL
DESQUESNES RENE INDIVIDUAL
M. & Mme. Capet INDIVIDUAL
M et Mme Jacques Charcot INDIVIDUAL
Landreau FAMILY NAME
Anne-Marie GIVEN NAME
BNP PARIBAS ORGANIZATION
MONTROSE LLC ORGANIZATION
IEEE ORGANIZATION
10 PLACE CHARLES DE GAULLE 74500 EVIAN LES BAINS FULL ADDRESS
10 PLACE CHARLES DE GAULLE DELIVERY ADDRESS
19104 Correze Tulle CITY-STATE/PROVINCE-POSTAL CODE
Bages CITY
Ardèche DEPARTMENT
Hauts-de-France REGION
02020 POSTAL CODE
(+33) 345-5789 PHONE
02-44-55-66-77 PHONE
février MONTH
161123345900149 SOCIAL SECURITY NUMBER
AT-535-JM VEHICLE REGISTRATION
Remarks The French, France implementation of the Field Content identification analysis definition does not identify data as STATE/PROVINCE. Instead, it identifies departments of France as DEPARTMENT and regions of France as REGION.

Some data has the potential for ambiguity. When conflicts occur, this definition uses the following priorities in this order to produce more accurate results when aggregating over a column of data:

  1. DATE
  2. MONTH
  3. DEPARTMENT
  4. SOCIAL SECURITY NUMBER
  5. REGION
  6. CITY
  7. PAYMENT CARD NUMBER or VEHICLE REGISTRATION
  8. COUNTRY