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