Just wonder how long we'll take to upgrade to this version ...
Teradata should backport these to v.12 and v.13 for slow-to-upgrade organisations
Original post ...
Just wondering if anyone out there has built Teradata UDFs to support Oracle-like regex functions to perform regular expression string manipulations.
Oracle has 4 very useful functions:
- regexp_like - to match regular expression patterns (used in the WHERE clause as per LIKE)
- regexp_replace - to replace the (nth occurring from position i - default is 1st from 1st) matching regular expression - this is sed-like in functionality with a similar \1..\9 replacement substitution mechanism
- regexp_substr - to return the (nth occurring from position i - default is 1st from 1st) matching regular expression pattern in the source (e.g. column)
- regexp_instr - to determine the position of the (nth occurring starting from the position i - default is 1st from 1st) matching regular expression in the source (e.g. column)
Also - can anyone point me to a good guide on building UDFs? And can these be developed and tested on Teradata Express?