• Invert Test - Select this to report the opposite results in your pass or fail file. For more information, see Invert Rule Test.

• Operator - Select from one of the following comparison operators:

• Constant - In this text box, type the constant value to compare, and then press the Enter key or click Add. For equal or not equal you can specify one or more constants.

• yyyy-mm-dd

• yyyy-mm-dd hh:mm:ss (military time)

• Invert Test - Select this to report the opposite results in your pass or fail file. For more information, see Invert Rule Test.

• Operator - Select from one of the following comparison operators:

• Compare Field - Select the required field to compare from.

• Results File - Displays the distinct values output file. Default is within your project. However, you can change it.

• /

• \

• .

• ,

• ..

• Results File - Displays the duplicate values output file. Default is within your project. However, you can change it.

• /

• \

• .

• ,

• ..

• RangeCount - Specify the number of ranges to create. The default is 10.

• Finds the lowest and highest values in the field to profile to determine the end points

• Creates Range Count equal-width ranges between highest and lowest values

• Counts the non-null values in each range

• int and long: interpolated breaks are whole numbers.

• float and double: interpolated breaks are double precision floating point values and can be values such as 1.6799999999999999995 due to floating-point roundoff error.

• numeric: interpolated breaks are rounded for presentation. The scale used when rounding is the scale of the minimum or maximum value (whichever is larger), plus a number of digits equal to the number of digits in the rangeCount..

• Invert Test - Select this to report the opposite results in your pass or fail file. For more information, see Invert Rule Test.

• Fuzzy Match Algorithm -

• Constant - In this text box, type the constant value with which to compare, and then press the Enter key or click Add. You can compare with multiple values.

• Fuzzy Score Filter - Add a decimal values between 0.01 to 1. Default value is 0.7. Comparison score is between 0 to 1. Records with comparison score less than this value are not considered a match for probable duplicates and are discarded. The higher the value you select, more strict is the matching.

• CONTAINS: Checks the small string in the long string.

• DAMERAU–LEVENSHTEIN: This distance between two strings is the minimum number of operations (insertions, deletions or substitutions of a single character, or transposition of two adjacent characters) required to change one string into another. For more information, see Damerau–Levenshtein distance.

• EXACT MATCH: Checks two strings for exact match.

• JARO: A measure of characters in common, being no more than half the length of the longer string in distance with consideration for transpositions.

• JARO-WINKLER: This algorithm extends Jaro algorithm and uses a prefix scale “p” which gives more favorable ratings to strings that match from the beginning for a set prefix length “l”. The prefix length is set to 4 characters (the maximum possible prefix length). For more information, see Jaro–Winkler distance.

• LEVENSHTEIN: This distance between two strings is the minimum number of single-character edits (insertions, deletions or substitutions) required to change one string into other. For more information, see Levenshtein distance.

• POSITIONAL QGRAM: Positional q-grams is an extension to q-grams with an additional property called maxDistance used in calculating the string similarity. For example, ‘peter’ contains the positional bigrams (‘pe’,0), (‘et’,1), (‘te’,2) and (‘er’,3). If maxDistance is set to 1, then (‘et’,1) will only be matched to bi-grams in the other string with positions 0 to 2

• QGRAM: q-grams (also called as n-grams) is the process of breaking up a string into multiple strings each with length n (q). For example, apply q-grams on abcde with q = 3 would yield abc, bcd, cde. For example, the word ‘peter’ with q=2 would yield following bigrams - ‘pe’, ‘et’, ‘te’ and ‘er’. A q-gram similarity measure between two strings is calculated by counting the number of q-grams in common.

• SHORTHAND: Determine if the shorter string is a “shorthand” of the longer. That is, if it can be produced only by deletions. If the first character of a word in the longer string is deleted, the entire word is considered deleted. For e.g. IBM is a shorthand of International Business Machines.

• Invert Test - Select this to report the opposite results in your pass or fail file. For more information, see Invert Rule Test.

• Invert Test - Select this to report the opposite results in your pass or fail file. For more information, see Invert Rule Test.

• Lower Bound - The lower range value. Select Inclusive to include the lower bound number in the range.

• Upper Bound - The upper range value. Select Inclusive to include the upper bound number in the range.

• yyyy-mm-dd

• yyyy-mm-dd hh:mm:ss (military time).

• AlphaNumeric Strings -->^[a-zA-Z0-9]+$

• AnyString-->.*

• ASCII characters only-->^([a-zA-Z0-9!\"#$%&',/:;<=>@_`|~ \\(\\)\\*\\+\\-\\.\\?\\[\\]\\\\\\^\\{\\}])*$")

• Canada Postal Code-->^([A-Za-z]\d[A-Za-z][\s-]?\d[A-Zaz]\d)

• Credit Card Number-->[1-9][0-9]{3} [0-9]{4} [0-9]{4} [0-9]{4}

• Date - mm/dd/yyyy format-->^(3[0-1]|2[0-9]|1[0-9]|0[1-9])[\s{1}|\/|-](Jan|JAN|Feb|FEB|Mar|MAR|Apr|APR|May|MAY|Jun|JUN|Jul|JUL|Aug|AUG|Sep|SEP|Oct|OCT|Nov|NOV|Dec|DEC)[\s{1}|\/|-]\d{4}$

• Date - YYMMDD format-->^((\d{2}((0[13578]|1[02])(0[1-9]|[12]\d|3[01])|(0[13456789]|1[012])(0[1-9] |[12]\d|30)|02(0[1-9]|1\d|2[0-8])))|([02468][048]|[13579][26])0229)$

• Days of Week-->^(Sun|Mon|(T(ues|hurs))|Fri)(day|\.)?$|Wed(\.|nesday)?$|Sat(\.|urday)?$|T ((ue?)|(hu?r?))\.?$

• Digits Only-->\d+

• Email Address-->^(([A-Za-z0-9]+_+)|([A-Za-z0-9]+\\-+)|([A-Za-z0-9]+\\.+)|([A-Za-z0-9]+\\++))*[A-Za-z0-9]+@((\\w+\\-+)|(\\w+\\.))*\\w{1,63}\\.[a-zAZ]{2,6}$

• ISBN_10 Number-->ISBN\x20(?=.{13}$)\d{1,5}([-])\d{1,7}\1\d{1,6}\1(\d|X)$

• Mr or Mrs-->Mr|Mrs

• Printable Characters-->^([a-zA-Z0-9!@#$%^&amp;amp;*()-_=+;:'&amp;quot;|~`&amp;lt;&amp;gt;?/{}] {1,5})$

• Single Alphabetic character-->^[a-zA-Z]$

• Social Security Number-->^[0-9]{3}-?[0-9]{2}-?[0-9]{4}$

• Time - hh:mm AMPM format-->^ *(1[0-2]|[1-9]):[0-5][0-9]*(a|p|A|P)(m|M) *$

• Time - hh:mm:ss format-->(([0-1][0-9])|([2][0-3])):([0-5][0-9]):([0-5][0-9])

• UK Postal Code-->^([A-Z]{1,2}[0-9]{1,2}|[A-Z]{3}|[A-Z]{1,2}[0-9][A-Z])( |-)[0-9][A-Z]{2}

• US Currency-->^\$?( )*\d*(.\d{1,2})?$

• US Phone Number-->^[01]?[- .]?\(?[2-9]\d{2}\)?[- .]?\d{3}[- .]?\d{4}$

• US Zipcode or Zip+4-->[0-9]{5}(-[0-9]{4})?

• Vehicle Identification Number (VIN)-->^(([a-h,A-H,j-n,J-N,p-z,P-Z,0-9]{9})([a-h,A-H,j-n,J-N,p,P,r-t,R-T,v-z,V-Z,0-9])([a -h,A-H,j-n,J-N,p-z,P-Z,0-9])(\d{6}))$

• AlphaNumeric - Matches strings that contain character and/or numeric data.

• AnyString - Matches all strings.

• ASCII characters only Postal- Matches ASCII characters only postal.

• Canada Postal Code - Matches postal code for Canada.

• Credit Card Number - Matches a credit card number.

• Date - mm/dd/yyyy format - Flexible date validator that matches most date formats.

• Date_YYMMDD - Date expression validator with format YYMMDD.

• Days of Week - Matches days of the week or their abbreviations.

• DigitsOnly - Expression for matching one or more digits.

• EmailAddress - Matches an email address.

• ISBN_10 Number - Matches format of an ISBN number.

• Mr or Mrs - Matches Mr or Mrs characters.

• Printable Characters - Matches all printable characters.

• Single Alphabetic character - Matches a single alphabetic Character.

• Social Security Number - Matches U.S. social security number. Dashes (-) are optional.

• Time - hh:mm AMPM format - Matches time format hh/mm AM.

• Time - hh:mm:ss format - Matches time format hh:mm:ss.

• US Zipcode or Zip+4 - Matches a US zip code.

• Vehicle Identification Number (VIN) - Matches US Vehicle Identification Numbers (VINs).

• Top How Many - Specify the number of desired frequent values. The default is 25, which returns the top 25 most frequent values.