1.3.3.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 |