Issue with regexp_replace in sql query

[Anonymous]

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]

here your regexp is apply on sql side.

[Anonymous]

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 · Accepted solution]

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

[manodwhb]

@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]

Thank you. It works.

Thanks,

Meghana.