Policy Guide › Search Text Syntax › Number and Money Variables

Number and Money Variables

Use the following search text variables to match numbers and money amounts.

Numbers

%DIGITS%

Matches a sequence of digits.

Example: invoice %digits% matches invoice 60340.

%DIGITS[X,Y]%

Matches a sequence of digits, whose value is between X and Y.

Example: %digits[100,200]% matches any number from 100 through 200.

Example: %digits[1,31]%/%digits[1,12]%/%digits[2005,2011]% matches all DD/MM/YYYY dates from 2005 through 2011, for example, 17/2/2011.

%INT%

Matches any integer.

Example: %int% matches 123 and -123 and 123,000. It does not match 123.4.

%FLOAT%

Matches any number with a decimal point.

Example: %float% matches 123.45 and -123.45 and 123,000.45. It does not match 123.

%NUMBER%

Matches any number, including numbers with decimal points or comma formatting.

Example: Buy %number% units at %money% each matches Buy 100 units at £34.45 each and Buy 100 units at £1,150 each.

%+NUMBER%

Must be a number.

Example: %+number% ??? matches three digit numbers such as 123.

%-NUMBER%

Disables %+NUMBER%.

Social Security Numbers

%SSN%

Matches a whole US social security number. That is, this variable identifies social security numbers both in nnnnnnnnn format and in nnn-nn-nnnn format.

Example: %SSN% matches 123456789 and 123-45-6789.

Note: CA Data Protection uses a sophisticated recognition process to cross-check against an imported system definition file. This file lists currently available social security numbers (the US Social Security High Group file). For details, see the Administration Guide; search for ‘system definition file’.

%SSN_U%

Matches a whole unformatted US social security number in nnnnnnnnn format.

Example: %SSN_U% matches 123456789 but not 123-45-6789.

%SSN_F%

Matches a whole formatted US social security number in nnn-nn-nnnn format.

Example: %SSN_F% matches 123-45-6789 but not 123456789.

Money and Credit Card Numbers

%MONEY%

Matches money amounts written using these formats: 99.00, $99 or $99.00, and USD 99 or USD 99.00. Equivalent formats for other currency codes and signs are also supported.

Example: %money% matches 6,217.50, $250, and USD 3,501.

Example: %money% matches €250, £250, and ¥250.

Example: %money% matches EUR 250, GBP 250, and JPY 250.

%CCN%

Matches a whole credit card number, ignoring all white spaces. A match also eliminates common false positives and validates the number using the Luhn algorithm. The matched card number is returned in a label %CCN% for use in smart tags and user notification messages.