All Forums Extensibility
StevenSchmid 33 posts Joined 07/11
07 Sep 2014
REGEXP_SUBSTR in Teradata 13.10

Hi
I was wondering if anybody had the regexp_substr UDF for Teradata 13.10 or the C code that can be used to create the UDF.  I realise that regular expression functions are available as part of the TD 14.0 release, however we have a need for the regexp_substr function in our current 13.10 release.  I have serached everywhere but can't find anything, if you are able to help, it would be much appreciated.
Cheers
Steven

Steven Schmid Teradata DBA Canberra, Australia
Raja_KT 1246 posts Joined 07/09
07 Sep 2014

I am not able to download the zip file. Did you try to see from here or simulate the same?
https://downloads.teradata.com/download/extensibility/teradata-udfs-for-popular-oracle-functions
I can see one here too:
https://jira.talendforge.org/browse/TDQ-8637
This one you may not need: http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs
However, it may help to copy paste the code :)

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

StevenSchmid 33 posts Joined 07/11
07 Sep 2014

Hi Raja
The oracle functions list contain functions like oreplace,  translate, rtrim, ... but not the regular expression functions.
The second link you provided has the function REGEXP_INSTR whch I also found, however I'm after the REGEXP_SUBSTR function.
Cheers
Steve

Steven Schmid
Teradata DBA
Canberra, Australia

Raja_KT 1246 posts Joined 07/09
07 Sep 2014

From github, we can get few ready made things, like 3d.js codes etc.
I have not tried this. Maybe you can have a look at it if it is similar.
https://github.com/hholzgra/mysql-udf-regexp/blob/master/regexp.xml
Please let us know if it works.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.