topic Issue with regexp_replace in sql query in Talend Studio

Issue with regexp_replace in sql query

Anonymous — Sat, 16 Nov 2024 07:34:52 GMT

Hi,

I am trying to run this query putting in tDBInput component. But I am getting error as Invalid character constant.

From my study, I understood that Talend doesn't accept regexp_replace. If yes, do we have any other alternate solution to do this.

SELECT '"'|| regexp_replace(to_char(sysdate,'dd-MON-yy'), '["]','""') ||'"' from dual

Thanks in advance,

Meghana.

fdenis — Wed, 26 Sep 2018 09:46:29 GMT

here your regexp is apply on sql side.

Anonymous — Wed, 26 Sep 2018 09:55:10 GMT

Sorry, I did not get u.

This query works fine in my sql developer. But I want to use this in Talend which I am unable to do. I hope u got my issue.

Thanks,

Meghana.

fdenis — Wed, 26 Sep 2018 09:59:25 GMT

use this into Query field:
"SELECT '\"'|| regexp_replace(to_char(sysdate,'dd-MON-yy'), '[\"]','\"\"') ||'\"' from dual"

manodwhb — Wed, 26 Sep 2018 10:03:18 GMT

@MeghanaKottala,i will suggest you to get the data using below query in tJavaRow use regular expression to replace.

SELECT to_char(sysdate,'dd-MON-yy') from dual

Anonymous — Wed, 26 Sep 2018 10:42:24 GMT

Thank you. It works.

Thanks,

Meghana.