I need to build a logic in mapping as below.
When a string of length 20 comes I got to pick first 19. When it comes of 15 i got to pick all 15. Can we do thorugh standard node functions ?? or we got to write UDF for this ??
then just write a UDF in which you will check the length of string(use .length function) ,now if this length is 20 then use substring function and pick up the first 19 characters else if length is 15,then simply return it as it is.