CHAR comparison

Compares two strings on a character-by-character basis. This comparison is often used to catch spelling mistakes or inverted letters.

If one string is shorter than the other, CHAR comparison pads the shorter column with trailing blanks to match the length of the longer column. Any mismatched character causes the disagreement weight to be assigned.

Required Columns

The following data source and reference source columns are required:

  • Data. The character string from the data source.

    You can use this comparison with vectors and reverse matching. To create vectors for use in the Match Designer, see Make Vector stage.

  • Reference. The character string from the reference source (only applies to a two-source match).