Standardizes acronyms for United Kingdom company names.

Standardizes United Kingdom company names.

Standardizes given names and removes extraneous character spaces.

Removes variations of the United Kingdom international dialing code from the start of the input string. For example,

+44

and

0044

Standardizes United Kingdom company name suffixes.

Replaces multiple consecutive spaces with a single space and trims leading and trailing spaces.

Removes the international dialing prefix from telephone numbers.

Removes the characters

X

and

9

.

Removes the first character from a number if the character is a zero.

Removes numbers from a string.

Removes all periods and left and right parentheses.

Removes all punctuation from the input field.

Removes all occurrences of a character space from the input field.

Replaces a limited set of punctuation symbols with character spaces.

Replaces all digits with

9

and all alphabetical characters with

X

.

Standardizes full names.

Converts the input text to title case.

Converts the input text to uppercase.

Validates the domain of an email address.

Identifies duplicate records in United Kingdom data based on company names and postal codes.

Identifies duplicate records in United Kingdom data based on surnames and National Insurance Numbers (NINO).

Identifies duplicate records in United Kingdom data based on surnames and United Kingdom postal codes.

Identifies duplicate records in United Kingdom data based on the following data:

First name
The first three characters in the surname
Date of birth
Postal code

Identifies duplicate records in United Kingdom data based on the following data:

Person name
Any two date of birth elements, such as month and year
United Kingdom postal code

Identifies records based on the following data:

Person name
Date of birth
Postal code

Identifies duplicate records in United Kingdom data based on company names and addresses.

Identifies duplicate records in United Kingdom data based on person names and email address data.

Identifies duplicate records in United Kingdom data based on person names and National Insurance Numbers (NINO).

Identifies duplicate records in United Kingdom data based on person names and postcode data.

Contains a list of domain names.

Contains geocoding status values and their descriptions.

Contains alphanumeric status values that indicate the outcome of the verification operation for an address. Each status value has a corresponding text description.

Contains United Kingdom bank sort codes.

Contains United Kingdom company name acronyms.

Contains sample United Kingdom company names.

Contains a list of United Kingdom company names.

Contains company suffix abbreviations in use in the United Kingdom.

Contains a list of names and corresponding genders in the United Kingdom.

Contains a list of United Kingdom nicknames.

Contains name prefixes and the gender associated with each prefix.

Contains a list of United Kingdom telephone area codes.

Contains a list of titles that precede personal names.

Labels two-digit United Kingdom telephone area codes.

Labels three-digit United Kingdom telephone area codes.

Labels four-digit United Kingdom telephone area codes.

Labels United Kingdom National Insurance Numbers (NINO).

Assigns the text description of a Geocoding Accuracy Code value that a verifier asset generates.

Assigns the text description of a Verification Status Code value that a verifier asset generates.

Validates the format of email addresses. The mapplet does not verify that the email addresses are accurate or active. Returns Valid or Invalid.

Validates the deliverability of United Kingdom addresses. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.

Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Discrete model in the verifier asset.

Validates the deliverability of United Kingdom addresses. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.

Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Hybrid model in the verifier asset.

Validates the deliverability of United Kingdom addresses. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.

Validates the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the mapplet when you can connect the input address fields to fields on the Multiline model in the verifier asset.

Parses an eight-digit string as a United Kingdom bank account number from a string.

Validates United Kingdom bank account numbers. The mapplet checks if the input is numeric and if the value is eight characters long.

Parses six-digit numeric strings as United Kingdom bank sort codes. The mapplet parses strings of numbers in the following formats:

Consecutive numbers (999999)
Numbers delimited with a dash (99-99-99)

Standardizes a United Kingdom bank sort code to the format NN-NN-NN.

Validates the format and length of United Kingdom bank sort codes that are standardized to the dash-delimited format (99-99-99). The mapplet returns a Status field that describes the validity of the sort code and a Validation Note field that explains the status. If the sort code prefix matches a known assignment for a United Kingdom bank, the validation note includes the bank name.

Identifies duplicate records in United Kingdom data based on company names and postal codes. The mapplet generates group keys from the postal codes.

Standardizes a company name and provides the acronym for the name if it is possible to do so.

Parses, standardizes, and validates United Kingdom contact data, such as addresses, telephone numbers, and National Insurance Numbers (NINO).

Parses strings that match the format of United Kingdom driver's license numbers from a string.

Validates United Kingdom driver's license numbers based on the requirements of the United Kingdom Government Data Standards Catalogue.

Identifies duplicate records in United Kingdom data based on surnames and National Insurance Numbers (NINO). The mapplet generates group keys from the NINO data.

Identifies duplicate records in United Kingdom data based on surnames and United Kingdom postal codes. The mapplet generates group keys from the postal code data.

Identifies duplicate records in United Kingdom data based on the following data:

First name
The first three characters in the surname
Date of birth
Postal code

Identifies duplicate records in United Kingdom data based on the following data:-

Person names
Any two date of birth elements, such as month and year
United Kingdom postal code

Identifies duplicate records based on the following data:

Person names
Date of birth
Postal code

Assigns gender to first names. The mapplet returns M for male names, F for female names, and U if the gender is unknown. For example, the mapplet assigns the name John Smith a gender of M for male.

Generate given names from United Kingdom nicknames. For example, the mapplet standardizes the nickname Bob to the given name Robert.

Identifies duplicate records in United Kingdom data based on company names and addresses.

Identifies duplicate records in United Kingdom data based on person names and email address data. The mapplet generates group keys from the email address data.

Identifies duplicate records in United Kingdom data based on person names and National Insurance Numbers (NINO). The mapplet generates group keys from the NINO data.

Identifies duplicate records in United Kingdom data based on person names and postal code data. The mapplet generates group keys from the postal code data.

Parses person name values into separate fields. The mapplet creates fields for values such as title, first name, middle name, and surname.

Parses National Health Service (NHS) numbers from a string.

Standardizes National Health Service (NHS) numbers into a standard format (999 999 9999). The mapplet requires that the input is a 10-digit string.

Validates National Health Service (NHS) numbers based on the check digit for each number. The mapplet requires that the input is a 10-digit string.

Validates that the input value conforms to a standard pattern for United Kingdom National Insurance Numbers (NINO). The mapplet does not verify that a NINO is accurate or active.

Parses United Kingdom National Insurance Numbers (NINO) from strings. The mapplet returns the NINO and also returns a string that contains the input text with the NINO removed.

CC NN NN NN C
CCNNNNNNC

Validates a United Kingdom National Insurance Number (NINO).

Parses United Kingdom passport numbers that appear in the machine-readable extended format.

Parses nine-digit strings that conform to the United Kingdom passport number format that the Government Data Standards Catalogue specifies.

Validates nine-digit strings that conform to the United Kingdom passport number format that the Government Data Standards Catalogue specifies.

Parses person name values into separate fields.

First name, middle name, last name

Parses the person name values into separate fields.

Last name, first name, middle name

Standardizes United Kingdom telephone numbers to international and local dialing formats. The mapplet recognizes telephone numbers that use leading zeros, the +44 international dialing code, and extensions that begin with the hash symbol.

Validates the area code and length of United Kingdom telephone numbers. The mapplet can also return the region that the area code identifies.

Parses United Kingdom postal codes from a string.

A9 9AA
A99 9AA
AA9 9AA
AA99 9AA
A9A 9AA
AA9A 9AA
GIR 0AA

Validates United Kingdom postal codes. If the mapplet does not find a postal code, it verifies whether the input follows a standard United Kingdom postal code pattern.

Converts input text to lowercase characters.

Assigns a name prefix based on gender. Includes a variable that can change a female prefix. For example, Ms. or Mrs.

Replaces multiple consecutive character spaces with a single space, and trims leading and trailing spaces.

Removes a leading zero from a number.

Removes all occurrences of a period and left and right parentheses.

Removes all punctuation symbols.

Removes all punctuation symbols and character spaces.

Removes all occurrences of a character space.

Replaces punctuation symbols, including a forward slash, backslash, exclamation point, period, or underscore character, with a character space. Also replaces instances of two, three, or four consecutive character spaces with a single space.

Generates formal and casual greetings from prefixes and names. For example, when input data contains "Mr. John Smith," the mapplet generates the formal greeting "Dear Mr. Smith," and the casual greeting "Dear John,". You can change the prefix and punctuation by editing the variables in the dq_Generate_Salutation Expression transformation.

Changes alphabetic characters to uppercase.

Assigns a gender value based on the first name.

Assigns a gender value based on the middle name.

Assigns a gender value based on the name prefix.

Parses a United Kingdom driver's license number from a string.

Parses a United Kingdom National Insurance Number (NINO) using a regular expression.

Parses a full name from the input field.

Parses a United Kingdom postcode that matches a United Kingdom postcode format.

Parses a United Kingdom postcode using a regular expression.

Parses the last alphabetical character from a string.

Parses a United Kingdom National Health Service (NHS) number using regular expressions.

Parses geocoding status descriptions.

Parses a United Kingdom account number.

Parses two-digit telephone area codes for the United Kingdom.

Parses three-digit telephone area codes for the United Kingdom.

Parses four-digit telephone area codes for the United Kingdom.

Parses United Kingdom bank sort codes.

Parses a United Kingdom bank sort code from the input data when an input value matches a value in a dictionary.

Parses name components for United Kingdom: F

Parses name components for United Kingdom: L

Parses United Kingdom passport numbers.

Parses machine-readable United Kingdom passport numbers.

Parses United Kingdom telephone numbers.

Parses United Kingdom postcodes using a regular expression.

Extracts the first alphabetical string from the input field where the alphabetical string is defined by a leading or trailing character space. For example, extracts

Check

from

Check Test

,

testword

from

testword 123

, or

Check

from

123 Check

.

Returns the text description of a Verification Status Code value that a verifier asset generates.

Verifies the deliverability of United Kingdom addresses. Use the asset when you can connect the input address fields to fields on the Discrete model.

Verifies the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the asset when you can connect the input address fields to fields on the Discrete model.

Verifies the deliverability of United Kingdom addresses. Use the asset when you can connect the input address fields to fields on the Hybrid model.

Verifies the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the asset when you can connect the input address fields to fields on the Hybrid model.

Verifies the deliverability of United Kingdom addresses and adds latitude and longitude coordinates to each valid address. Use the asset when you can connect the input address fields to fields on the Multiline model.

Parses unstructured United Kingdom addresses into address elements. Use the asset when you can connect the input address fields on the Multiline model.