Data8 Logo

DescriptionRequired DataUpload OptionsDownload OptionsOutput Columns
Name Cleansing
Cleanse a given name and identify gender.
Description

Tidy the supplied name, standardising casing and punctuation.

The gender is derived from the name where possible, and standard formal and informal salutations are generated.

This service is costed on a per record basis.

Required Data

This service requires the following data to be available before it can be used:

  • Person Name
Upload Options

The following options can be configured for this service at the upload stage.

Name Description
Separated Name
Separated Name

Splits a combined name into separate title, forename, middle name, surname and suffix fields to allow you to search your customer database more easily.

Gender
Gender

Adds a column to your data indicating if the person is believed to be male or female based on their name.

Salutation
Salutation

Appends the salutation that should be used when addressing the customer in a letter.

Name Data Level
Name Data Level

Indicates the amount of name information available for the customer.

Download Options

There are no options that can be configured for this service at the download stage.

Output Columns

This service adds the following columns to your output data.

Name Description
Title
Title

Title extracted from your name field or assumed where possible.

Forename
Forename

Forename extracted from your name field.

MiddleName
MiddleName

Middle name extracted from your name field.

Surname
Surname

Surname extracted from your name field.

Suffix
Suffix

Suffix extracted from your name field.

Gender
Gender

Gender derived from the forename, blank if forename is ambiguous e.g. Alex.

Formal Salutation
Formal Salutation

Appropriate text to use for salutation in a formal letter.

Informal Salutation
Informal Salutation

Appropriate text to use for salutation in an informal letter.

Name Data Level
Name Data Level

Amount of name information available.

An error has occurred. This application may no longer respond until reloaded. Reload 🗙