How to Use Topic Patterns in MapRStreams Data Objects

Back Next

Converting SQL Syntax to perl Compatible Regular Expression Syntax

If you are familiar with SQL syntax, use the following information to help you write perl compatible regular expressions.

The following table describes examples of SQL syntax and their perl compatible equivalents:

SQL Syntax	perl Syntax	Description
%	. *	Matches any string.
A%	A.*	Matches the letter “A” followed by any string, as in Area.
_	. (a period)	Matches any one character.
A_	A.	Matches “A” followed by any one character, such as AZ.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.