Forum Discussion

jpsheff's avatar
jpsheff
New Contributor
4 years ago

Replace parts of string with values from array of objects

I need to replace portions of a string with values from an array of objects: Input String: $string1 = 'SELECT * FROM TABLE A WHERE COL1 = #1 AND COL1 = #2;' In the following example I need t...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @jpsheff,

This can be achieved by using the .reduce() function. After you transform the parameter to an object field, use the following expression:

$parameters.reduce((acc,curr)=> acc.replaceAll(curr.name,curr.value),$string1)

Here’s a pipeline with the exact samples you provided, that does the transformation:

Replace string values from Array_2022_02_22.slp (5.3 KB)

I would suggest not to pass the JSON object as a parameter, if possible.

Regards,
Bojan