REGEXP_SUBSTR in Teradata 13.10

Extensibility
Enthusiast

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

Tags (1)
3 REPLIES
Enthusiast

Re: REGEXP_SUBSTR in Teradata 13.10

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 :)

Enthusiast

Re: REGEXP_SUBSTR in Teradata 13.10

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

Enthusiast

Re: REGEXP_SUBSTR in Teradata 13.10

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.