Name | Type | Description |
|---|---|---|
address_street_line_infa | Dictionary | Contains lists that help interpret the street line of addresses. |
calendar_month_frm_number_infa | Dictionary | Contains the names of the calendar months and the numerical equivalent for each month. For example, January and 1. |
calendar_months_infa | Dictionary | Contains the names of the calendar months. |
company_sufx_abrv_infa | Dictionary | Contains company suffix abbreviations. |
company_sufx_long_infa | Dictionary | Contains company suffixes. |
countries_infa | Dictionary | Contains the names of all the countries globally. |
Email_Domain_Name_Infa | Dictionary | Contains domain names for email addresses. For example, .com , .net, and so on. |
numbers_special_characters_infa | Dictionary | Contains a list of numbers and special characters including two spaces. |
phone_chars_infa | Dictionary | Contains a list of special characters that can be used as part of a phone number. |
timezones_infa | Dictionary | Contains a list of all timezones. |
US_Can_States_Infa | Dictionary | Contains the name of the states or provinces of the US and Canada. |
us_county_infa | Dictionary | Contains a list of the United States counties. |
usa_company_names_std_infa | Dictionary | Contains a list of company name standards in the United States. |
usa_firstnames_infa | Dictionary | Contains a list of the United States first names. |
usa_nicknames_infa | Dictionary | Contains a list of the United States nicknames. |
usa_surnames_infa | Dictionary | Contains a list of the United States surnames. |
Validate_Big_Integer | Dictionary | Validates if the input is a big integer. |
Validate_Calendar_Month | Rule Specification | Validates if the input is a month. |
Validate_Calendar_Quarter | Rule Specification | Validates if the input is a month, and returns the quarter. |
Validate_Calendar_Year | Rule Specification | Validates a date, and returns a calendar. |
Validate_Character | Rule Specification | Validates if the input is an alphabetical or a special character. |
Validate_CompanyName | Rule Specification | Validates if the input is a company name. |
Validate_Country | Rule Specification | Validates if the input country is valid. |
Validate_Currency | Rule Specification | Validates the input as currency Monetary amount for the price list.
|
Validate_Date_Creation | Rule Specification | Validates if the input is a date and returns the date in the DD-MM-YYYY format. |
Validate_Date_Measurement | Rule Specification | Compares the input date to the current time stamp. Also displays the date and time when the record was migrated. isNullable : true Traits: is.dataFormat.date means.measurement.date is.dataFormat.time means.measurement.time means.measurement.date.creation |
Validate_EmailAddress | Rule Specification | Validates if the input is an email address. |
Validate_FirstName | Rule Specification | Validates if the input is a first name. |
Validate_Integer | Rule Specification | Validates if the input is an integer.
|
Validate_LastName | Rule Specification | Validates if the input is a last name. |
Validate_Latitude | Rule Specification | Validates if the input is a valid latitude. |
Validate_Longitude | Rule Specification | Validates if the input is a valid longitude. |
Validate_MiddleName | Rule Specification | Validates if the input is a middle name. |
Validate_Month_frm_Quarter | Rule Specification | Validates the month from a date and returns the name of the month. |
Validate_NickName | Rule Specification | Validates if the input is a nickname. |
Validate_Phone_Fax | Rule Specification | Validates if the given input is a telephone or a fax number. |
Validate_Small_Integer | Rule Specification | Validates if the input string is a small integer. |
Validate_Street_Line | Rule Specification | Validates if the input is a valid street line in an address. |
Validate_Text | Rule Specification | Validates if the input is an alphabetical text. |
Validate_TickerSymbol | Rule Specification | Validates if the input is a valid ticker symbol. |
Validate_Timezone | Rule Specification | Validates a given timezone. |
Validate_URL | Rule Specification | Validates if the given input is a URL. |
Validate_US_Canada_StateName | Rule Specification | Validates if the input is United States state or Canada state or province name. |
Validate_USCounty | Rule Specification | Validates if the input is a United States county. |