Configuration Guide

Back Next

Types of String Matches

For the output string, you can specify one of the following match types:

Match Type	Description
Exact Match	Text string (for example, “IBM”). Note that string matches are not case sensitive. For example, the string test will also match TEST or Test.
Regular Expression	Pattern using the Java syntax for regular expressions (for example, “I.M.*” would match “IBM”, “IB Corp” and “IXM Inc.”). To parse a name field that consists of first, middle, and last names, you could use the regular expression (\S+$), which gives you the last name no matter what name you give it. The regular expression that is typed in as a parameter is used against the string and the matched output is sent to the outlet. You can also specify the group number to match an inner group of the regular expression. Refer to the Javadoc for java.util.regex.Pattern for the documentation on the regular expression construction and how groups work.
SQL Match	Pattern using the SQL syntax for the LIKE operator in SQL (for example, “I_M%” would match “IBM”, “IBM Corp” and “IXM Inc.”). If you use metacharacters such as the pipeline symbol (\|), the metacharacter must be delimited by an escape sequence such as backslash (\).