topic Re: Substring and CASE in Talend Studio

Substring and CASE

sszzxx — Mon, 22 Jan 2018 15:38:45 GMT

Hi, I have a question.

How do we use substr in talend? I have a case condition with substr and not sure how to go about it in Talend...

CASE
when ABC is null then NULL
WHEN ABC is not null and substr(ABC, 4,2) ='C' Then 'A'
when ABC is not null and substr(ABC,4,2) = 'Z' Then 'A'
ELSE 'E'

Thanks!

Re: Substring and CASE

lojdr — Mon, 22 Jan 2018 18:43:06 GMT

Hello,

Have you check component tMap?

Regards

lojdr

Re: Substring and CASE

sszzxx — Tue, 23 Jan 2018 01:20:22 GMT

Hi,

Yes I am using tmap component but I am not sure how to write the expression
for the condition stated.

Pretty sure it’s something like row1.xxx!=null?null:row1.xxx.equals() ...
that’s where I’m stuck at since there is a substr where I am supposed to
check what the alphabet at position number 4 is?

Re: Substring and CASE

lojdr — Tue, 23 Jan 2018 14:10:23 GMT

Hello,

This expression will be true if the string has on the 4th position character "a".

Regards

lojdr