You can translate the question and the replies:

REGEXP_LIKE function in a Scheduler query

Hello, I am trying to create a job in Scheduler, by putting a REGEXPLIKE function in the sql. The query which works in Oracle is: * SELECT FROM mytable WHERE REGEXPLIKE (referer,'^https?://[a-z6.]{0,9}\.?google[a-z]{0,11}\.[a-z]','i')* But this query does not work with Denodo. It gives Error: could not match input If I remove the REGEXP_LIKE expression it works. Also, if I revode the last argument **'i' ** still I have the same error. Any ideas? Thank you in advance
REGEXP_LIKE
user
08-01-2018 09:13:30 -0500
code

2 Answers

Hi, In Denodo Platform, you can use the 'regexp_like' comparison operator in the where clause to check if the parameter matches the regular expression as specified below, `Select <field_name> from <view_name> where <field_name> regexp_like '<regular_expression>'` You can have a look at the 'regexp_like' operator under [Comparison Operators](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/language_for_defining_and_processing_data_vql/comparison_operators/comparison_operators#comparison-operators) section of Virtual DataPort VQL Guide for more information on comparison operators. Hope this helps!
Denodo Team
09-01-2018 07:35:28 -0500
code
Thank you, indeed it works!
user
09-01-2018 08:35:06 -0500
You must sign in to add an answer. If you do not have an account, you can register here