topic StringHandling.LEN(col1) return -1 when value of col1 is null in Talend Studio

StringHandling.LEN(col1) return -1 when value of col1 is null

NarenS701 — Fri, 21 May 2021 10:43:20 GMT

Hi All,

Can someone explain why StringHandling.LEN returns -1 in below scenario?

StringHandling.LEN(col1) return -1 when value of col1 is null.

Anonymous — Fri, 21 May 2021 10:58:43 GMT

You can look into the source code of this function in Repository-->Code-->Routine-->System-->StringHandling.

public static int LEN(String string) {

return string == null ? -1 : string.length();

}

To avoid the value is -1 if it is null, you can set it to 0 with this expression on tMap.

row1.columnName==null?0:StringHandling.LEN(row1.column)

Regards

Shong

NarenS701 — Fri, 21 May 2021 11:12:05 GMT

Thank you @Shicong Hong