Latest Activity

Read URL from reverse

Dear all, i need to parse the url and get the last part of the string. for example : https://community.denodo.com/answers/question/manage or https://community.denodo.com/answers/question/manage/ i need to read the part "manage" i was earlier ...

REGEXP_LIKE Regex URL substring string conversion

Using Analytical Functions and REGEXP_LIKE function causes error

Currently running Denodo 8 and using some views connected to a Postgres 12.9 database. I found that when running a query with an analytical function sum() and a REGEXP_LIKE function, causes the following error: Finished with error: Error executing vi...

REGEXP_LIKE #Analytic function

LIKE is not working as expected

I am running this code on a Denodo database, SELECT TRUNC(tran_dttm) as dt, substr(device, 1, 3) AS tech, SUM(out_qty) AS moves FROM database.table WHERE facility IN '****' and device regexp_like '^P.*' AND tran_dttm >= DATE '2020-09-26' AND tran_d...

NOT LIKE REGEXP_LIKE Like

Help rewriting REGEXP_LIKE Query to VQL

We are needing some assistance/suggestions in rewriting the following Oracle query. Query is basically creating a list(listagg) of a list of regions gathered from abc.table123 (security config table, each row is different region), and then needs to be ...

VQL REGEXP_LIKE regexp_like Oracle SQL to VQL Converter SQL to VQL to_char

Using Regexp_like in Case in Select

Question about CASE in the SELECT statement of query. I have this in Oracle. CASE WHEN REGEXP_LIKE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG') THEN REGEXP_REPLACE (UPPER (MAIN_PRODUCT), 'CBMCLS|CBMOT|CBMSHG', 'CBM') ELSE UPPER(MAIN_PRODUCT) END AS ...

REGEXP_LIKE Select Query CASE

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 quer...

REGEXP_LIKE

Error Deploying Wrapper because of "regexp_like" in condition

I am having an issue deploying a wrapper that contains "regexp_like" in a condition for determining if each record that is iterated contains a firstname in the name column that is the same as entered at start. The "contains" function does not work as i...

VDP regexp_like ITPilot deploy