topic Re: How to NULL a value in a tMap Expression if it's over a certain character length. I need to trim values that are to long so the values don't truncate in Talend Studio

How to NULL a value in a tMap Expression if it's over a certain character length. I need to trim values that are to long so the values don't truncate

Anonymous — Thu, 02 May 2019 18:05:16 GMT

Hello Team of Talend Experts,

I need the syntax for a tMap Expression using Java Script that will NULL a value if it's over a certain character length say 30 characters. Also leave the other values under 30 characters the same and it's just a 1 for 1 mapping for the rest of the values.

Some Java Script Syntax example would be greatly appreciated

Re: How to NULL a value in a tMap Expression if it's over a certain character length. I need to trim values that are to long so the values don't truncate

TRF — Thu, 02 May 2019 19:25:17 GMT

On tMap right side use thé following expression for each concerned field:
row1.fieldname == null ||
row1.fieldname.length() > 30 ? null : row1.fieldname

Re: How to NULL a value in a tMap Expression if it's over a certain character length. I need to trim values that are to long so the values don't truncate

Anonymous — Fri, 03 May 2019 21:25:45 GMT

Thanks @TRF Solution Worked!