How to find variables in a formula

Topics: Help
Jun 14, 2012 at 8:28 PM
Edited Jun 14, 2012 at 8:31 PM

I load formulas at run time from a database and the values of variable (used in the formulas) comes from a different source. The formulas and the variables are stored in two separate dictionaries.

Dim dctFormulas as new dictionary(of string, string) 

dctFormulas.Add("f1", "if(v1>v2 and v3<v4, 'True', 'False')") 'formula Name and expression

At runtime I need to know variable names (v1,v2...) used in the formula(f1) so that I can do the following 

Dim exp1 = New Expression(dctFormulas("f1"), EvaluateOptions.IgnoreCase)

exp1.Parameters(variableName) = value