topic Re: LIKE operator in Talend in Talend Studio

LIKE operator in Talend

rishind — Sat, 16 Nov 2024 01:16:53 GMT

Hi,

How to use LIKE operator in Talend.

SO my requirement is I want to search a string which should Start with RS ,for example RSOP, RSTP, RSKK etc but it should not search string like PORS,PRSP .

I am using string.contains("RS"), but its not working accordingly .

I also tried s

tring.contains("RS.*") but it doesn;t give any result

Re: LIKE operator in Talend

rishind — Sun, 18 Oct 2020 10:45:15 GMT

I tried with string.startsWith("RS") and is working

but again is there any equivalent of LIKE in Talend

Re: LIKE operator in Talend

vikramk — Tue, 20 Oct 2020 08:14:29 GMT

You could use left function in Talend to get the desired output.

Please let me know if it helps.

Re: LIKE operator in Talend

manodwhb — Tue, 20 Oct 2020 08:19:35 GMT

@rish ind , you can use the below way.

String.contains("RS")

Thanks,

Manohar