PREFIX comparison

Compares two strings on a character-by-character basis after right-truncating the longer string so that it contains the same number of characters as the shorter string.

Required Columns

The following data source and reference source columns are required.

  • Data. The string from the data source.

    You can use this comparison with vectors and reverse matching. If you want to create vectors to use in the Match Designer, see Make Vector stage.

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

Example

This comparison uses the shorter length of the two strings for the comparison and does not compare any characters after that length.

For example, a last name of ABECROMBY might be truncated to ABECROM. The PREFIX comparison considers these two representations to be an equal match. This comparison is different from the CHAR comparison, where these two names do not match. The length is computed by ignoring trailing blanks (spaces). Embedded blanks are not ignored.