Compiling PHP's Eval() to .NET • Hacker News Board

Post by rajeev-k » Mon, Feb 17, 2020, 4:16 PM UTC

senthil_rajasek wrote: post #8

rajeev-k wrote: post #4

I needed the ability to safely execute formulas in my .NET app. My solution was to write a parser and interpreter. Here it is: https://github.com/Rajeev-K/formula-parser

Do you have examples of the types of "formulas" that you wanted to execute? Also, how would one execute said formula?

Any valid Visual Basic.NET expression is supported. Here are some examples:

  (latestquote - previousquote) / previousquote
  iif(isonlineorder, "Online", "Retail")
  FirstName & " " & LastName
  iif(IsNothing(Amount), "Amount missing",  Format(Amount, "c2"))
  "Q" & ((OrderDate.Month - 1) \ 3 + 1)
  MonthName(DatePart(DateInterval.Month, Today), false)
  DateAdd(DateInterval.Day, 1, Today)

See this file for example of usage: https://github.com/Rajeev-K/formula-parser/blob/master/src/R...