Uses Europe based endpoint to access email verification algorithm that identifies valid and non-valid email addresses.

Uses United States based endpoint to access email verification algorithm that identifies valid and non-valid email addresses.

Global Phone Validation is a data validation and enrichment service for telephone numbers throughout the world, accessed through an Europe based endpoint.

Global Phone Validation is a data validation and enrichment service for telephone numbers throughout the world, accessed through a United States based endpoint.

Inserts a character space on either side of an ampersand, and reduces multiple spaces to a single space.

Inserts a character space on either side of a hyphen, and reduces multiple spaces to a single space.

Inserts a character space on either side of a period, and removes multiple spaces.

Returns descriptions for a Match Code value that a verifier asset generates.

Returns descriptions for the Address Type Codes.

Returns descriptions for Result Quality.

Returns descriptions for verification status codes.

Concatenates two words with a space.

Standardizes country names to their respective two-letter ISO country codes.

Standardizes country names to their respective three-letter ISO country codes.

Assigns labels to alphanumeric values.

Returns ISO country name for any country identifier in an input field.

Identifies default or sample date values such as 00/00/0000.

Identifies default or sample numeric values such as 0 or 999.

Identifies default or sample alphabetic values such as XXX, NA and Default.

Converts the input text to lowercase.

Merges the Remainder, Unparsed and Overflowed columns from the parser.

Merges the Before, After, Overflow and Unparsed columns from the parser. Removes leading and trailing spaces.

Merges multiple input fields into a single field.

Merges two ports together to create one output port

Removes all apostrophe characters from the input.

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

Removes all hyphens from an input string.

Removes zero at the start of an input string.

Removes any forward slash, backslash, exclamation point, period, or underscore character from an input string.

Removes all occurrences of left and right parentheses from a string.

Removes a period from a string.

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

Removes all occurrences of punctuation from the input field.

Removes all double quotes from a string of text.

Removes all occurrences of forward and back slashes in a string.

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

Removes all spaces from an input string.

Merges two ports and removes any spaces around and between.

Replaces an ampersand character with a character space.

Replaces forward-slash with backward-slash.

Replaces letters that use diacritic symbols with their English-language counterparts.

Replaces a hyphen or underscore character with a space.

Replaces a hyphen with a space and reduces multiple spaces to a single space.

Replaces any forward slash, backslash, exclamation point, period, or underscore character with a character space. Also replaces instances of multiple character spaces with a single space.

Replaces a number or other non-alphabetic character with a space, and reduces multiple spaces to a single space.

Replaces a period with a character space.

Replaces any slash symbol with a character space.

Converts the input text to title case with dictionary-defined exceptions.

Trims leading and trailing spaces from the input string.

Converts the input text to uppercase.

Validates the domain of an email.

Contains a set of characters (A-Z , a-z , 0-9).

Contains a list of characters that use diacritics symbols.

Contains a list of domain names.

Contains a list of result quality codes with 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 a list of the result quality codes that Address Verification version 6 engine returns with descriptions.

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

Contains the short and long forms of country names and their respective two-letter and three-letter ISO country codes.

Assigns numeric values.

Contains a list of sample or default values.

Contains a list of suspect names.

Contains a set of valid calendar date formats.

Contains the cities of the world.

Contains the colors of various shades.

Contains a list of color names and their alternatives.

Contains a list of currency and country codes.

Contains the standardized currency codes of all the currencies in the world.

Contains a list of currency symbols for the respective currency.

Contains the number of the month.

Contains the standard DD/MM format for the days and months of the year.

Contains a list of English letters.

Contains the consonants of the English language.

Contains a list of household elements.

Contains the two-character ISO country code and the corresponding country name.

Contains the three-character ISO country code and the corresponding country name.

Contains the general list of job positions.

Assigns labels to alphabetical characters, spaces and non-alphabetical characters.

Replaces a number or other non-alphabetical characters with 9/S.

Contains the list of major cities.

Calculates the minimum cost of transforming one string to another through insertion, deletion, or replacement of characters.

Calculates a match score for two strings by computing the number of positions in which characters differ between the strings. For strings of different length, each additional character in the longest string is counted as a difference between the strings.

Reflects the degree of similarity between the first four characters of both the strings and the number of identified character transpositions.

Calculates a match score for two strings by computing the number of positions in which characters differ between the strings. For strings of different length, the algorithm counts each additional character in the longest string as the difference between the strings.

Contains the integer value of the corresponding month of the year.

Contains the number of the month in a year. For example, 01 for January, 02 for February.

Contains version 2012 of the North American Industry Classification System (NAICS) codes and descriptions.

Contains version 2017 of the North American Industry Classification System (NAICS) codes and descriptions.

Contains version 2022 of the North American Industry Classification System (NAICS) codes and descriptions.

Contains version 2022 of the North American Industry Classification System (NAICS) codes and descriptions with NAICS description as a valid column.

Contains NAICS to SIC codes crosswalk.

Contains lists of process status values from version 5 and version 6 of the address verification engine.

Contains a list of profane words.

Contains a list of quantities. For example, length, mass, time, area, acceleration.

Contains the different races of the world.

Contains a list of religions.

Checks if the input value is numeric or non-numeric.

Prepends zero to a single digit. If the input data is not a single digit, the data is returned.

Removes all the zeros at the beginning of an input string.

Contains Standard Industrial Classification (SIC) to North American Industry Classification System (NAICS) codes and descriptions. SIC is designated a valid column.

Contains Standard Industrial Classification (SIC) codes and descriptions and their closest 2012 North American Industry Classification System (NAICS) codes and descriptions.

Contains Standard Industrial Classification (SIC) codes and descriptions and their closest 2017 North American Industry Classification System (NAICS) codes and descriptions.

Contains the standard phone formats of the EMEA region.

Contains the list of surname with common surname prefixes like "Mc" or "Mac".

Contains list of words that are title case exceptions. The capitalized major words and minor words are in lowercase.

Contains the abbreviations of the Unit of Measures (UOM).

Returns the International country phone code when the country name or ISO code is passed.

Adds a leading zero to a string input.

Adds an open parenthesis at the beginning and a close parenthesis at the end of an input string.

Inserts a plus sign in front of an input string.

Inserts a space on either side of an ampersand, and removes multiple spaces.

Ensures that a single space precedes and follows a dash or a hyphen.

Adds a space between a single digit and a single letter. For example, 3G is returned as 3 G.

Inserts a character space on either side of a period, and removes multiple spaces.

Removes all leading and trailing spaces from an input string.

Describes the match score value that a verifier asset returns.

Describes the Match Score value that a verifier asset returns for the address verification version 6 engine.

Calculates a match score for two data strings based on the occurrence of consecutive characters in both strings. The mapplet looks for pairs of consecutive characters that are common to both strings. It divides the number of pairs that match in both strings by the total number of character pairs.

Compares two dates in an input of type string and returns four outputs. The outputs represent the difference between the dates in hours, days, months, and years respectively. The output values are exclusive of each other. Do not use them together to represent the difference between the data values.

Checks if the input field is empty or null.

Checks if the input field is empty or null. The mapplet has ten input and output ports.

Concatenates two strings with a character space as the join character.

Converts the process status values that version 5 of the address verification engine generates to their version 6 equivalents.

Reads a country name as input and returns the full ISO country name, the ISO three-letter country code, and the ISO two-letter country code.

Checks if an input date string matches any user-defined default value. Does not validate the input string as a date.

Checks the number of years between the input date and the current date. Returns whether the years represent an adult or a minor.

Formats an input date string using user-defined variables. Includes the exp_ParseDate and exp_FormatDate transformations. Input dates that are invalid or do not fit the designated input format are written as all zeros.

Validates an input date string. The input date format variable allows the user to specify the input date format.

Validates an input date string. The input date format variable allows the user to specify the format the input date should be in.

Calculates the difference between the two dates in days. The result is the difference between the end date and the start date. Input data type should be set as String.

Calculates the number of days between an input date and the current date (system date). Sets the expected input type as String.

Parses an email from within a string of text.

Validates the email format. It does not check if the email is an activated address. Returns Valid or Invalid.

Calls the email web service to process emails.

Validates the deliverability of address records from multiple countries. The mapplet corrects errors where possible. Use the rule with input address fields in a hybrid format.

Flags suspicious or fake names in input data.

Checks if input data is numeric.

Converts input text to lowercase characters.

Checks if an input is a number and less than zero.

Checks the completeness of a number field. Checks that the field contains a number, is not null or blank, and does not match a sample or default value.

Parses alphabetic characters and spaces from non-alphabetic characters.

Parses the first text string from an input field, reading from left to right. Uses a character space to delimit text strings.

Parses a number that occurs at the end of an input string, reading from left to right.

Parses a number that occurs at the beginning of a string.

Parses a text string between left and right parentheses from an input field.

Parses a text string between single quotes from an input field. If there are multiple instances, the final occurrence in the field is parsed out.

Flags a past date as invalid, and converts a future date to the current system date.

Prepends a zero to a single digit. If the input is not a single digit, returns the input data.

Removes any leading zero from number data.

Removes apostrophes from a string.

Identifies and removes non-printable characters in an input field.

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

Removes all hyphens from an input string.

Removes a leading zero from a string.

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

Removes all characters that are not a digit or number from an input string.

Removes all occurrences of left and right parentheses from a string.

Removes all occurrences of a period from a string.

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

Removes all punctuation symbols from the input.

Removes all punctuation symbols and character spaces from an input field, and returns the remaining digits and letters.

Removes all double quotation marks from a string of texts. Does not replace with character spaces.

Removes all occurrences of forward slashes and backslashes in a string of text.

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

Replaces an ampersand symbol with a character space.

Replaces forward slash or backslash symbols with a character space.

Replaces any occurrence of a hyphen with a single 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.

Replaces all non-alphabetic characters with a character space. Trims multiple successive spaces to a single space.

Replaces any occurrence of a period with a character space.

Replaces punctuation symbols with a character space.

Replaces all occurrences of a forward slash or backslash with a character space.

Reverses the order of the characters in an input field.

Checks if an input field is empty, null, or contains sample or default values.

Converts input text to title case, with dictionary-defined exceptions.

Changes alphabetic characters to uppercase.

Validates the check digit of a number. Returns valid if the check digit (the final digit of the input) is correct. Returns invalid for incorrect check digits and for all non-numeric input.

Returns the number of years since a given date.

Parses an email from a string of texts, provides the elements of mailbox, domain and sub-domain, and validates if the structure and domain are valid. It does not check if the email is an activated address.

Parses an email into its constituent elements of mailbox, domain and sub-domain. For example,

info@informatica.com

will be parsed into

info

(mailbox),

informatica

(sub-domain), and

com

(domain). The mapplet assumes that the text being entered is a valid email.

Mapplet calls the Email Web Service to process emails. Email Verification combines state-of-the-art email verification algorithms with hygiene algorithms to allow customers to detect and avoid dangerous or potentially dangerous email addresses or domains.

Mapplet calls the Telephone Web Service to process global telephone numbers. Global Phone Validation is a data validation and enrichment service for telephone numbers throughout the world.

Mapplet calls the Telephone Web Service to process global telephone numbers. Global Phone Validation is a data validation and enrichment service for telephone numbers throughout the world.

Translates diacitical characters to regular ascii text characters. For example, it changes an

ë

to an

e

(returns

tëst

as

test

).

Identify and parse control characters from input string.

Parses an email address from a text string.

Parses the first word of a string.

Parses a number at the beginning of a string.

Parses a number that occurs at the end of a string.

Parses suspicious names.

Parses text between parentheses.

Parses the first word (sub-domain) of an email address.

Parses top level domain of an email address.

Parses text between single quotes.

Covers general, address, contact, corporate and product data. Copy the content of the bundle to a project or folder. Use the copies or update them as per the business requirement of the user. This bundle is updated from time to time, and modifications will not affect the changes that users make in the copied assets.

Verifies if the input is null.

Takes the date input fields and combines them to create a date that consists of year, month, day, hour, minute, second, nanosecond. Minimum input required is year, month, day.

Takes an input string in the mm/dd/yyyy format and converts it to the date/time format.

Converts input strings to lowercase.

Converts input strings to sentence case.

Converts input strings to title case.

Converts input strings to toggle case.

Converts input strings to uppercase.

Returns the year from a date/time input in the format yyyy-mm-dd or yyyy-MM-dd HH:mm:ss.SSS.

Adds a number that you specify to the day, month, or year value in the date.

Merges two input strings into a single output, with a dash (-) as the join character.

Merges two input strings into a single output, with a character space as the join character.

Concatenates two strings into a single string with no join character.

Identifies null values in an input field. Returns

1

for a null value, and returns

0

if the input is not null.

Returns a value from a string that contains multiple delimited values. The value is determined by an integer in the first input that the rule specifies.

Removes an input string that the rule specification logic specifies.

Removes international dialing code data from an input string.

Removes spaces at the start and end of an input string.

Removes multiple character spaces from an input string.

Finds and replaces input strings that the rule specification logic specifies.

Sorts a list of values in numerical order or alphabetical order and returns the highest value from the list. The values must be the same data type.

Returns the lessor of two values across two input fields on the same data row.

Returns the number of characters in a string.

Returns the characters and data in an input string in reverse order.

Returns the text description of a match code value that a verifier asset generates.

Returns the ISO country name for any country identifier in an input field.

Standardizes the currency symbol based on current symbol, three-letter code, or full currency name.

Truncates a float data value to two decimal places. Does not perform rounding.

Updates an input date in the format yyyy-mm-dd to the final day of the month. Returns the date in the format yyyy-mm-dd hh:mm:ss.s.

Cross-references the input values with entries in a specified dictionary and replaces them with a custom string.

Verifies that date1 precedes date2.

Validates the deliverability of address records from multiple countries and corrects errors where possible. The asset is configured to read input address fields in a hybrid structure.