tmap trimming an entry - problem when entry is empty (cannot invoke "String.substring(int,int)" because "row.A" is null)

[Moro]

Hi all!

I have been trying to trim an entry in a table but I keep getting the following error:

Cannot invoke "String.substring(int,int)" because "row.A" is null

The way I did it:

In tmap I tried to check first if the entry is empty and then do the trimming like the following

row.A == null ? row.A : (row.A.length() >10 ? StringHandling.LEFT(row.A,4):row.A)

It is not working. Any suggestions from your side?

Thank you!

[Moro]

So true! Thank you very much! It works!