String Search in Teradata CLOB

Database

String Search in Teradata CLOB

Hi,

Would you please anybody help me answering

How to perform a string search in Teradata CLOB clumns?

Thanks a lot for your help!!

1 REPLY

Re: String Search in Teradata CLOB

The new Regular Expression functions like "REGEXP_INSTR" can search a CLOB.

The example in the Teradata documentation is:

SELECT REGEXP_INSTR('Hello Santa says ho ho', 'ho', 1, 2, 0, i);

returns the result 21.

 

Other regular expression functions are:

They are very interesting and powerful, but take work and time to learn.

I enjoyed reading Satyaki De's Wordpress blog (http://bit.ly/1kM4WRh), and there are many resources to learn regular expressions.