topic tOracleInput using regexp, Invalid escape sequence in Talend Studio

tOracleInput using regexp, Invalid escape sequence

Anonymous — Fri, 16 Jun 2017 20:12:16 GMT

Hello all

How to use in SQL query in tOracleInput statements like this?

select

...

REGEXP_COUNT(p.num,'[А-Яа-я]|[;]|(\,\ \ )|(\ \,)|(\w\ \w)|(\w\,\w)') field1,
REGEXP_COUNT(p.num,'([a-zA-Z0-9.\_\-])+[\@]+([a-zA-Z0-9.\_\-]){0,61}+[\.]+[a-zA-Z]{2,6}') field2,

....

When I build job I got error Invalid escape sequence (valid ones are \b \t \n \f \r \" \' \\ )

replace all '\' on '\' doesn't help

Re: tOracleInput using regexp, Invalid escape sequence

cterenzi — Fri, 16 Jun 2017 23:21:29 GMT

Your sql string is interpreted by Java first, then passed to Oracle. In your tOracleInput sql, replace all '\' with '\\'.

Re: tOracleInput using regexp, Invalid escape sequence

Anonymous — Sat, 17 Jun 2017 06:04:18 GMT

I've done this replace, don't help

Re: tOracleInput using regexp, Invalid escape sequence

cterenzi — Sat, 17 Jun 2017 15:57:09 GMT

If you get the same error message, you missed one.

Re: tOracleInput using regexp, Invalid escape sequence

Anonymous — Sun, 18 Jun 2017 10:16:15 GMT

Thank yoy, I really missed one