Forum Discussion

RaymanPrince's avatar
RaymanPrince
New Contributor II
4 years ago

To replace more than one character in string by looking up another field value

I have a business requirement, where we have below JSON in that, have to update object’s field called TRANSLATION_ID by looking up another fields called VARIABLE_ID and VARIABLE_VALUE. Here if both V...
Cele's avatar
Cele
New Contributor II
4 years ago
Copy LinkReport

Hi @RaymanPrince

You can try to use the expression below in a mapper

$VARIABLE_ID != null && $VARIABLE_VALUE != null && $.extend({ 'TRANSLATION_ID': $VARIABLE_ID.split(',').reduce((acc, cur, index) => acc.replaceAll([cur], $VARIABLE_VALUE.split(',')[index]),$TRANSLATION_ID) }) || $
  • parthiban_jks's avatar
    parthiban_jks
    New Contributor II
    4 years ago
    Copy LinkReport

    Hi Cele,

    Thanks you so much for the quick reply. Could you please explain about the reduce part in the above expression? I would be really helpful for us

    Thanks,
    Parthiban S