topic Re: How to pass a String correctly in Talend Studio

How to pass a String correctly

Anonymous — Sat, 17 Feb 2018 10:41:52 GMT

how can i pass String in active express Builder ?

am doing like this

am not getting any output.

Re: How to pass a String correctly

TRF — Sat, 17 Feb 2018 12:36:01 GMT

Hi,

You are trying to filter a tMap output flow to keep only rows associated to the input flow "row1" for which DEVICEID is equal to "LAB0115AN3131 " (including the final space.

2 things:

- are you sure about the final space?

- most important, you should never compare 2 strings using the "==" operator but only the "equals" or "equalsIgnoreCase" method like this:

row1.DEVICEID.equals("LAB0115AN3131 ")

(or maybe without the final space).

Hope this help.

Re: How to pass a String correctly

manodwhb — Mon, 19 Feb 2018 09:07:00 GMT

when it is string field ,use the below expression in active experss Builder.

row1.DeviceId.equals("LAB0115ANS3131 ")

if you have null data in row1.DeviceId,you may get null pointer exception

for that use below expression.

("LAB0115ANS3131 ").equals(row1.DeviceId)

Re: How to pass a String correctly

TRF — Mon, 19 Feb 2018 09:25:01 GMT

@ksingh, did this help you.

In this case, thank's to mark your cae as solved (Kudo also accepted).

Re: How to pass a String correctly

Anonymous — Wed, 21 Feb 2018 11:01:24 GMT

am doing this and am not getting any output. Please suggest me something which will helpful for me

Re: How to pass a String correctly

manodwhb — Wed, 21 Feb 2018 11:41:40 GMT

do you have data space like after the end of the value "LAB0115ANS3131 ",if not please remove space.

Re: How to pass a String correctly

manodwhb — Wed, 21 Feb 2018 11:42:52 GMT

can you try with row1.DeviceId.equals("LAB0115ANS3131") ?

Re: How to pass a String correctly

Anonymous — Wed, 21 Feb 2018 13:23:00 GMT

am not getting any output . now what i will do ?

Re: How to pass a String correctly

TRF — Wed, 21 Feb 2018 13:36:53 GMT

Hi,

As said in my 1rst answer, it seems you have a space at the and of the string used in your expression.

Is it normal?

However, you may also use a tFilterRow in such a case if you just want to exclude rows not matching with your filter.

Re: How to pass a String correctly

Anonymous — Wed, 21 Feb 2018 13:52:29 GMT

its normal. when u told me about space am checked and remove space after that run my job. its full scan but not provide any output. the STRING which am used in express builder am copy from database. means that string is exist in my database.

Re: How to pass a String correctly

TRF — Wed, 21 Feb 2018 14:43:03 GMT

I suppose there is no filter on the input side.

So, maybe a non editable character into your database field value (?)

Just for testing, can you replace the expression by the following (to ignore the last character):

row1.DeviceId.startsWith("LAB0115AN3131")

Re: How to pass a String correctly

Anonymous — Thu, 22 Feb 2018 09:42:50 GMT

am not getting any row in my database.when am using row1.DeviceID.startsWith("LAB1216AN3012")

am also try row1.DeviceID.contains("LAB1216AN3012"). my output database is empty.

when i will use only mapping not any condition than am getting output.

please kindly help me.

Re: How to pass a String correctly

Anonymous — Thu, 22 Feb 2018 09:47:34 GMT

where is my fault ? if there is another way please suggest me.

Re: How to pass a String correctly

manodwhb — Thu, 22 Feb 2018 09:53:59 GMT

can you check your data,is it have in UPPER case or LOWER case values?

if you have lowercase use ignore case or StringHandling.UPCASE functions.

LAB1216AN3012 or lab1216an3012

Re: How to pass a String correctly

TRF — Thu, 22 Feb 2018 09:58:33 GMT

Strange.

Replace your database by a file and remove the tMap expression filter then search for the value in the file using your prefered text editor to check that your data arrive as expected.

Re: How to pass a String correctly

Anonymous — Thu, 22 Feb 2018 10:05:52 GMT

uppercase or lowercase no issue.

Re: How to pass a String correctly

manodwhb — Thu, 22 Feb 2018 10:13:33 GMT

no issue means is your issue fixed?

Re: How to pass a String correctly

Anonymous — Thu, 22 Feb 2018 11:40:57 GMT

lower case and upper case is not issue. my problem is not fixed now.

am also trying different approach due to it am not responding instant.

when my problem is fixed i will Accept as Solution because i don't want my problem became anybody headache.

Re: How to pass a String correctly

Anonymous — Tue, 06 Mar 2018 09:33:57 GMT

Dear Folks

Please provide me solution related my post.

Re: How to pass a String correctly

Anonymous — Tue, 06 Mar 2018 09:47:05 GMT

Can you try

(row1.DeviceId).equals("LAB0115ANS3131 ") ?

with braces around the variable.