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...
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'
Solved! Go to Solution.