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.
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
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.
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