Parses each word in a space-delimited string to a separate port.

Adds the numeral "0" to the beginning of a string.

Adds parenthetical symbols at the start and end of a string.

Adds the plus symbol at the start of a string.

Adds a space before and after all ampersands in a string.

Adds a space before and after all dashes and hyphens in a string.

Adds a space in between a character pair composed of one numeral and one alphabetic character. Reading from left to right, the mapplet adds a space to the first numeral-alphabetic character pair in the data.

Adds a space before and after all periods in a string.

Removes all leading and trailing spaces from the input data fields.

Assigns a description to the Address Resolution Code output from the Address Validator transformation.

Assigns a description to the Element Input Status output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Assigns a description to the Element Relevance output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Assigns a description to the Element Result Status output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Assigns a description to the Extended Element Result Status output from the Address Validator transformation.

Assigns a description to the Geocoding Status output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Assigns a description to the Mailability Score output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Assigns a description to the Match Code output from the Address Validator transformation. The description corresponds to the output from Data Quality transformations in releases prior to Data Quality 9.0.

Classifies a string as one of the following languages: Arabic, Dutch, English, French, German, Italian, Portuguese, Russian, Spanish, or Turkish. The rule uses the Language_Classifier content set to identify the languages.

Hours
Days
Months
Years

Checks a single port for NULL values. Returns "Complete" if the port contains data. Returns "Incomplete" if the port is empty or contains a NULL value.

Checks multiple ports for NULL values. Returns "Complete" if all ports contain data. Returns "Incomplete" if any port is empty or contains a NULL value.

Concatenates two fields. Uses a character space as a separator.

Converts the output from the Match Code port in an Address Validator transformation to the equivalent address validation match code in Data Quality 8.6.

American Express
Diners Club Carte Blanche
Diners Club International
Diners Club US & Canada
Discover Card
JCB
Maestro
Master Card
Solo
Switch
Visa
Visa Electron

Checks the number of years between a date of birth and the current date. Returns "Adult" or "Minor" in addition to "Valid" if the number of years 120 or lower. Returns "Invalid" if the number of years is greater than 120.

dd/mm/yyyy
mm/dd/yyyy
yyyy/dd/mm

Standardizes date strings to an output format that you specify. To set the output format, open the dq_FormatDate Expression transformation in the rule and update the Output_Date_Format expression variable and the Delimiter expression variable. If the input data does not describe a valid date, the rule returns the digit 0 for each input character.

Validates date strings that appear in a single format in a data column. To configure the date format that the rule uses for validation, open the dq_ValidateDate Expression transformation in the rule and update the In_Date_Format expression variable. The default format is "MM/DD/YYYY." The rule returns "Valid" or "Invalid."

Validates date strings that appear in multiple formats in a data column. Use the rule when a data source includes the following columns:

A column that contains date values in multiple formats.
A column that identifies the format of the date value in each row. If the column does not identify a date format for a row, the rule applies the format "MM/DD/YYYY" to the date value.

Calculates the number of days between two dates.

Calculates the number of days between a specified date and the current date.

Validates an International Article Number. The rule returns "Valid" if the check digit is correct for the number and "Invalid" if the check digit is incorrect.

Validates a Global Trade Item Number (GTIN). The rule validates eight-dight, twelve-digit, thirteen-digit, and fourteen-digit numbers. The rule returns "Valid" if the check digit is correct for the number and "Invalid" if the check digit is incorrect.

Verifies that the input data is numeric. The rule returns "True" or "False."

Returns all alphabetic characters in lower case.

Applies the Luhn algorithm to a numeric string. The rule can validate numeric strings, such as credit card numbers.

Checks input data for profanity. Masks profanity as "CENSORED" in the output data.

Validates that the input data is a negative number.

Checks for NULL values in numeric inputs.

Identifies the alphabetic characters and the non-alphabetic characters in an input string and writes each set of characters to different output ports. For example, the rule parses the following values from the input string

teststring_123

:

Parses the first word in an input string to a port that the rule specifies.

Parses any number that occurs at the end of an input string to a port that the rule specifies. The rule reads strings from left to right.

Parses any number that occurs at the start of an input string to a port that the rule specifies. The rule reads strings from left to right.

Compares strings to a reference table of profane terms and parses any term that matches a reference table value to a port that the rule specifies.

Parses strings that are enclosed in parentheses to a port that the rule specifies. The rule contains an output port for the parsed strings and an output port for the input text without the parsed strings.

Parses strings that are enclosed in quotation marks to a port that the rule specifies. When the input data contains multiple quoted elements, the rule parses the final element. The rule reads the input strings from left to right. The rule contains an output port for the parsed strings and an output port for the input text without the parsed strings.

Determines whether an input date is earlier than the system date or later than the system date.

Person name
Company name
Data category, such as person name or company name
Data that the rule cannot parse

Verifies that the input data is a positive number.

Prepends the numeral "0" to single numeric characters.

Removes all instances of the numeric character "0" from the beginning of a string.

Removes apostrophes. The rule merges the text strings on either side of the apostrophe.

Removes control characters from text strings. The rule returns a string that contains the control characters and a string that contains the input text without the control characters.

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

Removes hyphens.

Removes a single instance of the numeric character "0" from the beginning of a string.

Removes extraneous characters. Extraneous characters include slashes, back slashes, periods, exclamation marks, underscores, and multiple consecutive spaces.

Removes all characters that are not numeric.

Removes right and left parenthesis symbols.

Removes periods.

Left and right parentheses
Periods

Removes punctuation symbols.

Removes all punctuation and all space characters.

Removes quotation marks.

Removes forward slashes and back slashes.

Removes all character spaces.

Replaces ampersands with spaces.

Replaces hyphens and underscores with spaces.

Replaces hyphens with spaces.

Replaces the following punctuation characters with a single space: dash, back slash, period, exclamation mark, and underscore. The rule also replaces two, three, and four consecutive spaces with a single space.

Replaces numerals and punctuation characters with a single space.

Replaces periods with a single space.

Replaces all punctuation with spaces.

Replaces forward slashes and back slashes with spaces.

Reverses the order of characters in input strings.

Checks a string for completeness. The rule also searches the input strings for values in the reference table string_default_values_infa. The reference table contains values such as NA, DEFAULT, and XX. If an input string contains a value in the reference table, the rule identifies the string as incomplete.

Converts strings to title case. In title case strings, the first letter of each word is capitalized.

Replaces diacritic characters with ASCII equivalents. For example, the rule converts "ã" to "a".

Returns all alphabetic characters in upper case.

Validates the format and structure of a URL.

Calculates the number of years since the input date.