Ignore double blackslash in Talend

[Parikhharshal]

Hi experts

While executing the SQL I have got below statement:

regexp_instr( lower(md.name), ' ^(week |module) \\ d+ ')

I have put in as part of tDbRow component. As soon as Talend executes this it just skips and doesn't process data for that column.

How can I ignore or skip double backslashes?

Thanks

Harshal.

[Parikhharshal · Accepted solution]

I was able to find the solution.

Need to another 2 backslashes to ignore.

regexp_instr(lower(md.name), '^(week|module) \\\\d+')