Ignore double blackslash in Talend

Parikhharshal — Sat, 16 Nov 2024 04:13:49 GMT

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.

Re: Ignore double blackslash in Talend

Parikhharshal — Tue, 29 Oct 2019 23:40:19 GMT

I was able to find the solution.

Need to another 2 backslashes to ignore.

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