topic Re: tMap - IF ELSE statement fails in Talend Studio

tMap - IF ELSE statement fails

Anonymous — Sat, 16 Nov 2024 05:10:53 GMT

Hi,

I have this table and I'm trying to apply a conditional statement to get a boolean to find out if the 5th position of the field DATE is char "/"

I've made it in two steps, first I've applied this statement to get the "/" from the 5th position:

StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,5),1)

That works, but when I add the contitional expression, It doesn't work and all I got are 0:

StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,5),1) == "/" ? 1:0

Could someone help me, please?

Thank you!!

Re: tMap - IF ELSE statement fails

lennelei — Wed, 24 Jul 2019 12:16:18 GMT

Hello,

== is an operator comparing objects in your example, not their content!

Comparing strings can be made with the .equals() method of the String object :

"/".equals(StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,5),1))?1:0

Or with the .equals method of the Objects object (you may have to import it first) :

Objects.equals("/", StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,5),1))?1:0

You can also use other methods depending on your needs (.compareTo() for example)

Re: tMap - IF ELSE statement fails

Anonymous — Wed, 24 Jul 2019 15:21:26 GMT

Thank you!!

By the way, now I'm trying to apply the same rule to determine if the 5th and 6th characters are smaller than 12.

<= 12 (StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,7),2)) ?1:0

Could you please tell me which would be the correct sentence?

Thank you!!

Re: tMap - IF ELSE statement fails

lennelei — Wed, 24 Jul 2019 15:32:20 GMT

if (StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,7),2)) returns the correct part of the String, and you are sure it will be a number, you may do

Integer.parseInt(StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,7),2))) <= 12

In this case, you can use <= as you are comparing an int primitive with the value 12

Re: tMap - IF ELSE statement fails

Anonymous — Wed, 24 Jul 2019 15:50:38 GMT

Yes, I've tried this sentence, the problem is that not always will be a number, here's an example on which it's "/2":

Re: tMap - IF ELSE statement fails

lennelei — Wed, 24 Jul 2019 15:59:43 GMT

Then you should test the value before:

First add a tMap variable testValue with this code :

Integer.parseInt(StringHandling.RIGHT(StringHandling.LEFT(row1.DATE,7),2)))

And then use this in your test:

Var.testValue.matches([0-9]+)?Integer.parseInt(Var.testValue)<=12:false

This will test if your substring contains only digits. If yes, this will return if that number is less or equal than 12. If no, this will return false.

Re: tMap - IF ELSE statement fails

Anonymous — Wed, 24 Jul 2019 16:37:37 GMT

I've tried adding the testValue and then executing this sentence:

Var.testValue.matches([0-9]+)?Integer.parseInt(Var.testValue)<=12:false

And I have this error:

Thank you for your time

Re: tMap - IF ELSE statement fails

lennelei — Wed, 24 Jul 2019 16:50:46 GMT

Of course, I forgot to quote the regex

Var.testValue.matches("[0-9]+")?Integer.parseInt(Var.testValue)<=12:false