tOracleInput using regexp, Invalid escape sequence

Five Stars

tOracleInput using regexp, Invalid escape sequence

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

 


Accepted Solutions
Ten Stars

Re: tOracleInput using regexp, Invalid escape sequence

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

All Replies
Ten Stars

Re: tOracleInput using regexp, Invalid escape sequence

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

Re: tOracleInput using regexp, Invalid escape sequence

I've done this replace, don't help

Ten Stars

Re: tOracleInput using regexp, Invalid escape sequence

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

Re: tOracleInput using regexp, Invalid escape sequence

Thank yoy, I really missed one