Search and replace values in script

[#1]

Hello,

I've the following 2 tables. What I wan to do is the following:

• search the values in the left table and replace them in the formula in the right table (no idea on how to proceed)
• evaluate the formula (I know how to do that, with the evaluate() function)

I must do that in the script!

Has anyone an idea or some useful functions ? It's clear that I will have to loop over the field Formula, but how to find the value in the left table ?

Thanks!

IP

[Gysbert_Wassenaar]

See attached qvw

[#3]

Thank you for your help. I must now search how to do this dynamically.

Regards,

IP