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

 

  • Data Integration
1 ACCEPTED SOLUTION

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 '\\'.
4 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