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/Output

Number of Connections: Min: 1/Max:4

Input	Data Type	Description
Input1	String	The string to perform the regular expression against.
Input2	String	Sets the RegExp property. (optional)
Input3	Integer	Sets the Offset property. (optional)
Input4	Integer	Sets the Count property. (optional)

Output	Data Type	Description
Output1	String	The regular expression results.

Property

Name	Property Type	Description
RegExp	string	The regular expression.
Offset	int	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.
Count	int	In 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.
CaseInsensitive	choice	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

• This component supports generic regular expressions and Perl5 regular expressions. For information regarding the JAVA package this component uses to implement regular expression queries refer to http://jakarta.apache.org/oro/api/org/apache/oro/text/regex/package-summary.html.

Regular Expression Dialog

When double-click the regular expression functions, the Regular Expression Dialog is displayed. You can configure the properties and test the regular expressions.

　

　

Fields

Regexp	Input regular expression property. When the item is selected by listing the lower right of the screen, the corresponding regular expression is set.
Input string	Input the string to be used by test.
Result	The result of test is displayed.
Other property	Properties of editing function is displayed except for regular expression.
Selection list	If selects the category, regular expressions are displayed below. The corresponding regular expression is reflected in the input column when the item is selected from the list, and the explanation is displayed under the screen.
Test button	Test the current configurations with Input string.
Edit sample button	Edits the regular expression list of Selection List.

　

Regular expression list is simple CSV file and it is freely customizable.

　

Specification of regular expression sample data

• The file path is DESIGNER_HOME/resources/Regexp/Regexp.txt
• Comment the line started with "#"
• Column 1 - Categor
• Column 2 - Label displayed in the list
• Column 3 - Regular expression
• Column 4 - Description(Line feed is "\n")

Example

Example 1 : Define the string format to match using the brackets "()" and Offset property.

		Property		Output
Input1	abc,filename20021231.txt	RegExp	[a-zA-Z]*([0-9]*).txt	20021231
		Count	0
		Offset	1
		CaseInsensitive	false

Example 2 : In the case of multiple matches, the Count property specifies which match is output.

		Property		Output
Input1	abc,filename20021231.txt,filename20030101.txt	RegExp	[a-zA-Z]*([0-9]*).txt	20030101
		Count	1
		Offset	1
		CaseInsensitive	false