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

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) }) || $
RaymanPrince's avatar
RaymanPrince
New Contributor II
4 years ago

Hi @Cele

Many Thanks
The solution works as expected.