REGEXP

The REGEXP function outputs the portion of the input string that matches the specified regular expression.

This component supports generic regular expressions and Perl5 regular expressions.

Input

Number of Connections: Min: 1/Max:4
InputData TypeDescription
Input1StringThe string to perform the regular expression against.
Input2StringSets the RegExp property. (optional)
Input3IntegerSets the Offset property. (optional)
Input4IntegerSets the Count property. (optional)

Output

OutputData TypeDescription
Output1StringThe regular expression results.

Property

NameProperty TypeDescription
RegExpStringThe regular expression.
OffsetInteger

Specifies which group in the pattern match is to be returned. A group is defined in the regular expression with open ("(") and close (")") brackets.

"(0)" will return all results.

CountIntegerIn the case that the RegExp pattern matches the search string multiple times, this value determines which match iteration is used for determining the return value. If set to '0' (the default) the first match is used.
CaseInsensitivechoice Defines whether the query distinguishes from upper and lower case characters.

true - does not distinguish between upper and lower case
false - does distinguish between upper and lower case

Topic


Example

Example 1 : Define the string format to match using the brackets "()" and Offset property.
PropertyOutput
Input1abc,filename20021231.txtRegExp[a-zA-Z]*([0-9]*).txt20021231
Count0
Offset1
CaseInsensitivefalse

Example 2 : In the case of multiple matches, the Count property specifies which match is output.
PropertyOutput
Input1abc,filename20021231.txt,filename20030101.txtRegExp[a-zA-Z]*([0-9]*).txt20030101
Count1
Offset1
CaseInsensitivefalse