LIKE operator in Talend

[rishind]

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

[rishind · Accepted solution]

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

but again is there any equivalent of LIKE in Talend

[vikramk]

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

Please let me know if it helps.

[manodwhb]

@rish ind​ , you can use the below way.

String.contains("RS")

Thanks,

Manohar