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.
I am not able to download the zip file. Did you try to see from here or simulate the same?
I can see one here too:
This one you may not need: http://developer.teradata.com/blog/madmac/2010/03/
However, it may help to copy paste the code :)
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.
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.
Please let us know if it works.