creating algorithm for formula parsing

[VM]

I'm trying to find out what the best way would be to parse a formula so I
can then calculate it with its real values.
For example, a user may enter
((sys_empHours*db_empSal)/db_totalHours)
and I would need to parse all of that so that I can get the tokens that need
to be replaced with data (sys_empHours, db_empSal, etc...) and then plug
them back in.

Thanks.

 

[Kieran Benton]

You might also want to look into generating code dynamically and
compiling it (very fast and efficient and extremely flexible). Heres
an example that could be modified to do what you want:
http://www.codeproject.com/csharp/matheval.asp

HTH
Kieran