Is there any way to use a Regular Expression with Teradata version 12?
You could wrap a C-grep into a UDF, but don't expect high performance.
Are there any plans for Regular Expressions to be available in the future without needing rights to create a UDF?
Regular Expressions as part of the Teradata toolbox would be incredibly useful and significantly improve data quality work. Doing this type of thing in an external ETL tool can be done, but it is time consuming and it'd be nice to use the MPP power of teradata here as well...
Teradata insiders are not permitted to talk about features of future product versions that have not been officially announced. Since the content of the upcoming Teradata 14.0 was announced at last week's Partners conference, we can now mention that one of the 14.0 features is a set of system functions that accept regular expressons as arguments. The set includes REGEXP_SUBSTR, REGEXP_REPLACE, REGEXP_INSTR, REGEXP_SIMILAR, and REGEXP_SPLIT_TO_TABLE.
Please let me know how to use REPLACE function to extract 3 digits from any value (Ex. 'CDI_101HAIFA').
I am using TERADATA 13.