formula parser .......

Question

0.00/5 (No votes)

See more:

hi...
I want to create a formula parser which can parse formulas similar to the ones created in Excel...
for example formula like...
If(Condition(s),ValueIfTrue,ValuIfFalse)

can anyone please tell me if I can get such a parser....

Posted 6-Apr-11 23:14pm

Amrita Thakur

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sergey Alexandrovich Kryukov · Answer 1 · 2011-04-06T23:30:00

Solution 1

You can avoid creating your own parser. You can use the one already available as a C# or VB.NET compiler, which are the part of Framework redistributable and are always available via CodeDOM.

Here is how to do it:
code generating using CodeDom[^];
See also:
Create WPF Application that uses Reloadable Plugins...[^].

—SA

Posted 6-Apr-11 23:30pm

Sergey Alexandrovich Kryukov

Updated 6-Apr-11 23:32pm

v2

Comments

Nuri Ismail 7-Apr-11 6:02am

Good advice. My 5.
And your linked answers, I wish I could give more than 5 for them. :)

Sergey Alexandrovich Kryukov 7-Apr-11 6:13am

Do you means you voted 5 three times? This is more then enough :-)
Thank you, Nuri.
--SA

Nuri Ismail 7-Apr-11 6:16am

Yes I 5-ed the linked answers, too. But IMHO, your efforts deserve more... :)

Sergey Alexandrovich Kryukov 7-Apr-11 12:35pm

Thank you. You not gonna believe that, but I just answered another Question about using CodeDOM and dynamically compiled Assembly with even more tricky (and crazy, of course) requirements.

This is most funny:
http://www.codeproject.com/Answers/178490/how-to-get-the-text-of-a-label-using-codedom.aspx

I suspect the patient has no idea where she or he is trying to get into. Hope my answer can be sobering, no more. I can't believe that new OP would be able to write anything working in any observable period of time. And the purpose of it hardly can justify such work.

Take a look, this is really funny.

--SA

Nuri Ismail 8-Apr-11 5:49am

This sounds very interesting. I'll check out your answer right now. :)

Sergey Alexandrovich Kryukov 7-Apr-11 12:40pm

Amrita,

Please understand that my absolute skepticism about the work of the other Inquirer commented above has nothing to do with your work. In contrast to that crazy (but probably somehow interesting) Question, your work is quite realistic and makes full sense.

You purpose is probably compiling and running some calculation. Doing it with CodeDOM is quite feasible and has one big benefit: instead of inventing and processing your own syntax and language rules you use something available, robust and well tested. It can justify your effort.

--SA

walterhevedeich 7-Apr-11 21:49pm

Good point. voted 5.

Sergey Alexandrovich Kryukov 7-Apr-11 22:54pm

Thank you.
--SA

Wendelius · Answer 2 · 2011-04-07T08:57:00

Solution 2

This article could be interesting for you: Evaluation Engine[^]

Posted 7-Apr-11 8:57am

Wendelius

Comments

walterhevedeich 7-Apr-11 21:49pm

Good point. voted 5.

Wendelius 8-Apr-11 1:24am

Thank you :)

CPallini · Answer 3 · 2011-04-07T10:06:00

Solution 3

Have also a look at Simple Math Parser[^].
:-)

Posted 7-Apr-11 10:06am

CPallini

Comments

walterhevedeich 7-Apr-11 21:49pm

Good point. voted 5.