Description
Compares an input string to a regular expression. A regular expression (regex) is a textual pattern. This function returns a value whether or not the regex finds a match.
Syntax
REGEXMATCH ( input, regex )
| Parameter | Description |
|---|---|
| input | String to be matched to the regular expression. |
| regex | The regular expression. |
Remarks
For an overview of Regular Expressions, refer to About Regular Expressions.
There are several sites that allow you to refine or test your regular expression before adding it to this function in your DTS file. For help with creating regular expressions, TIBCO suggests that you do an internet search on the phrase Regex Builder to find useful resources.
Examples
The following example attempts to match the pattern "Main" in source field S3.
REGEXMATCH(S3, "Main")
For a record with S3 containing "123 S. Main Street, Bedford, MA", the function returns TRUE. Whereas, a source value of "5 River Rd., Boston, MA" returns FALSE.
See also