All Forums General
anishgoyal007 7 posts Joined 02/14
22 Sep 2015
Regular Expression guide for regular expression functions

Is there any document available for understanding the regular expressions used by regular expression functions like REGEXP_SUBSTR, REGEXP_SIMILAR etc.

Anish Goyal

dnoeth 4628 posts Joined 11/04
23 Sep 2015

There's no Teradata-specific documentation on regex, but there are many books and online resources available, simply google for "regular expression".
Caution, there are different dialects for regex, but Teradata usually follows the Perl variant (Perl Compatible Regular Expressions = PCRE).

Dieter

anishgoyal007 7 posts Joined 02/14
23 Sep 2015

Thanks Dieter. That is why I was wondering why some of the regular expressions are not working. I was using regular expressions used in sed, awk.

Anish Goyal

You must sign in to leave a comment.