topic issue with string compare in tMap in Talend Studio

issue with string compare in tMap

Anonymous — Sat, 16 Nov 2024 14:01:01 GMT

Hi,
Not sure is there something wrong with the expression
(StringHandling.LEFT(row1.text1,3)=="PNL" ?(row1.text1):" not matching")
here is the data from the file

QU HDQPNSY
.HDQRMSY 242150
PNL
SY0341/25MAR MSP PART3
-MCO121Y-PAD006
1HECKT/ALEXANDER-AM4 .R/CTCT MSP612 338 8880 A
.R/CTCH MSP763 545 9319 H .L/NWZAEA
1HECKT/CATHERINE-AM4
1HECKT/OLIVIA-AM4
and I am getting "not matching for all the rows"
Thanks,

Re: issue with string compare in tMap

Anonymous — Fri, 27 Mar 2009 16:17:08 GMT

Hello,
With java : do not use == to compare String.
you should use the equals methode like this :

(StringHandling.LEFT(row1.text1,3).equals("PNL")?(row1.text1):" not matching")

Re: issue with string compare in tMap

Anonymous — Fri, 27 Mar 2009 16:27:28 GMT

Thanks a lot emenuet, now its working as expected !