Monday 4 July 2011

Question: Anyone built UDFs to handle regexp functions

Was talking to Teradata CTO, Stephen Brobst this week (21/11/11) and he confirmed these functions will be available in Teradata v. 14 ...
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?

No comments: