1.3.4.9.23 Match Transformation: Strip Numbers

The Strip Numbers match transformation allows you to remove all numbers from String values before comparing them. This works in exactly the same way as the main Strip Numbers processor.

Use the Strip Numbers transformation when you are matching on an identifier where the correct values should not contain any numbers, but where there may be stray numbers in the data that will degrade your matching results, or in any other scenario where you want to match the non-numeric part of the String.

For example, when matching inventory items, some descriptions may contain extraneous serial numbers that cannot be used reliably to match records. These may be stripped out so that the user can match the text descriptions.

Options

None

Example

The Strip Numbers transformation is being used in a comparison on an inventory item description identifier.

Example transformations

The following table shows transformations using the Strip Numbers transformation:

Table 1-96 Example Transformations for Strip Numbers

Value	Transformed Value
POLO SHIRT XTR L 1156662	POLO SHIRT XTR L
POLO SHIRT 19" XTR L 8755261	POLO SHIRT " XTR L
1625765 MENS ACTIV SPORTS SHORTS	MENS ACTIV SPORTS SHORTS
MENS 7651234 ACTIV SPORTS SHRTS	MENS ACTIV SPORTS SHRTS