 |
|
 |
Thank's to Michael, i was looking for this so far, i need it to create a application that one of feature is calculate a value based on dynamic formula. i think it's can overcome my problem. thank's again Micahel, Great Success for you
|
|
|
|
 |
|
|
 |
|
|
 |
|
 |
You should use decimal point (as your result shows)
|
|
|
|
 |
|
 |
A math expression evaluator is working so nicely. When i look at the code I don't understand how you come up with the state table numbers?
Dim state(,) As Integer = {{2, 4, 1, 1, 4, 6, 7}, _
{2, 3, 3, 3, 3, 3, 3}, _
{1, 1, 1, 1, 1, 1, 1}, _
{2, 4, 5, 5, 4, 5, 5}, _
{1, 1, 1, 1, 1, 1, 1}, _
{1, 1, 1, 1, 1, 1, 1}, _
{1, 1, 1, 1, 1, 1, 1}}
|
|
|
|
 |
|
 |
calc.evaluate("25!-24!*25") says -2147483648 instead of 0
|
|
|
|
 |
|
 |
-2147483648 seems like lower bound for integer.. 25! is a huge number..
Burak SARICA
|
|
|
|
 |
|
 |
I can't get my calculator to give decimals
Part of the code is:
textbox2.text=int(textbox1.text / 10)
if i type ex. 56 it gives 5 for 83456 it gives 83456 and so on...
how do i make the decimals???
David Dlaka
|
|
|
|
 |
|
 |
This is just what we have been looking for .
I have made some mods to include a stack etc so we can go back and use or mod any calcs.
It would be quicker to use if all inputs used the keybord ie
1+2+3+4+5+6 then insted of using the mouse just press "Enter" or "Return" to do the evaluation.
Cnn this be achived ?
If so can some one give me a hint.
Thanks
|
|
|
|
 |
|
 |
just put a button to do the funtion and then click enter thats one simple way that worked for me
David Dlaka
|
|
|
|
 |
|
 |
Anyone knows a good evaluator to solve equations ?
eg. x+5=10
|
|
|
|
 |
|
 |
Hey guys, I've done some changes to this excelent parser to get ternary expressions evaluated. It must be in the following way {contition ? trueValue : falseValue } Supported operators <, >, ==, !=, <=, >=, &, |, ! Sqare parenthesis "[ ]" are used for grouping conditions Example : {(6+5) * 8 > 5 & ![(6+4) /2 > 5] | 7*3-5 < 15 ? 9 * 2 : 6 / 4} Here is the code Option Strict On Imports System.Collections Imports System.Collections.Generic Imports System.Text.RegularExpressions Namespace ExpressionEvaluator Public Class ExpressionEvaluator
Private Class eeSymbol Implements IComparer Public Token As String Public Cls As ExpressionEvaluator.TOKENCLASS Public PrecedenceLevel As PRECEDENCE Public tag As String Public Delegate Function compare_function(ByVal x As Object, ByVal y As Object) As Integer
Public Overridable Overloads Function compare(ByVal x As Object, ByVal y As Object) As Integer Implements IComparer.Compare Dim asym, bsym As eeSymbol asym = CType(x, eeSymbol) bsym = CType(y, eeSymbol)
If asym.Token > bsym.Token Then Return 1 If asym.Token < bsym.Token Then Return -1 If asym.PrecedenceLevel = -1 Or bsym.PrecedenceLevel = -1 Then Return 0 If asym.PrecedenceLevel > bsym.PrecedenceLevel Then Return 1 If asym.PrecedenceLevel < bsym.PrecedenceLevel Then Return -1 Return 0 End Function End Class Private Enum PRECEDENCE NONE = 0 LEVEL0 = 1 LEVEL1 = 2 LEVEL2 = 3 LEVEL3 = 4 LEVEL4 = 5 LEVEL5 = 6 End Enum Private Enum TOKENCLASS KEYWORD = 1 IDENTIFIER = 2 NUMBER = 3 [OPERATOR] = 4 PUNCTUATION = 5 End Enum Private m_tokens As Collection Private m_State(,) As Integer Private m_KeyWords() As String Private m_colstring As String Private Const ALPHA As String = "_ABCDEFGHIJKLMNOPQRSTUVWXYZ" Private Const DIGITS As String = "#0123456789" Private m_funcs() As String = {"sin", "cos", "tan", "arcsin", "arccos", _ "arctan", "sqrt", "max", "min", "floor", _ "ceiling", "log", "log10", _ "ln", "round", "abs", "neg", "pos"} Private m_operators As ArrayList Private m_stack As New Stack() Private Sub init_operators() Dim op As eeSymbol m_operators = New ArrayList() op = New eeSymbol() op.Token = "-" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL1 m_operators.Add(op) op = New eeSymbol() op.Token = "+" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL1 m_operators.Add(op) op = New eeSymbol() op.Token = "*" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL2 m_operators.Add(op) op = New eeSymbol() op.Token = "/" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL2 m_operators.Add(op) op = New eeSymbol() op.Token = "\" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL2 m_operators.Add(op) op = New eeSymbol() op.Token = "%" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL2 m_operators.Add(op) op = New eeSymbol() op.Token = "^" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL3 m_operators.Add(op) op = New eeSymbol() op.Token = "!" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL5 m_operators.Add(op) op = New eeSymbol() op.Token = "&" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL5 m_operators.Add(op) op = New eeSymbol() op.Token = "-" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL4 m_operators.Add(op) op = New eeSymbol() op.Token = "+" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL4 m_operators.Add(op) op = New eeSymbol() op.Token = "(" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL5 m_operators.Add(op) op = New eeSymbol() op.Token = ")" op.Cls = TOKENCLASS.[OPERATOR] op.PrecedenceLevel = PRECEDENCE.LEVEL0 m_operators.Add(op) m_operators.Sort(op) End Sub
Public Function evaluate(ByVal expression As String) As Double Dim symbols As Queue Try If Regex.IsMatch(expression, "[{].*[}]") Then ' Created by Jorge Gaona ' 06/08/2007 Dim s, e As Integer s = expression.IndexOf("{") e = expression.LastIndexOf("}") expression = Regex.Replace(expression, "[{].*[}]", evaluateCondition(expression.Substring(s + 1, e - s - 1))) End If
If IsNumeric(expression) Then Return CType(expression, Double) calc_scan(expression, symbols) Return level0(symbols) Catch 'MsgBox("Invalid expression") Throw New Exception("Invalid Expression") End Try End Function Public Function evaluateCondition(ByVal expression As String) As String ' Created by Jorge Gaona ' 6/8/2007 Try Dim condition, trueValue, falseValue As String '[{]+\w+[}]' condition = expression.Split(CChar("?"))(0).Trim() trueValue = expression.Split(CChar("?"))(1).Split(CChar(":"))(0).Trim() falseValue = expression.Split(CChar("?"))(1).Split(CChar(":"))(1).Trim() Dim operatorStack As New List(Of String) Dim postfix As New List(Of String) Dim logicOperator, character, item As String 'Dim logicPrecedence As Int16 item = "" logicOperator = "" For i As Integer = 0 To condition.Length - 1 character = condition.Substring(i, 1) Select Case character Case "<", ">", "!", "=" If i + 1 <= condition.Length Then If condition.Substring(i + 1, 1) = "=" Then logicOperator = character & "=" i = i + 1 Else logicOperator = character End If End If If item.Trim <> "" Then postfix.Add(item.Trim) item = "" End If Case "]", "&", "|", "[" logicOperator = character If item.Trim <> "" Then postfix.Add(item.Trim) item = "" End If Case Else item += character End Select Dim insert As Boolean If logicOperator <> "" Then Do If operatorStack.Count > 0 And logicOperator <> "[" Then If logicOperator <> "]" Then If getLogicOperatorPrecedence(operatorStack(operatorStack.Count - 1).ToString) _ > getLogicOperatorPrecedence(logicOperator) Then postfix.Add(operatorStack(operatorStack.Count - 1)) operatorStack.RemoveAt(operatorStack.Count - 1) insert = False Else operatorStack.Add(logicOperator) insert = True logicOperator = "" End If Else If operatorStack(operatorStack.Count - 1).ToString <> "[" Then postfix.Add(operatorStack(operatorStack.Count - 1)) operatorStack.RemoveAt(operatorStack.Count - 1) insert = False Else operatorStack.RemoveAt(operatorStack.Count - 1) 'operatorStack.Add(logicOperator) insert = True logicOperator = "" End If End If Else operatorStack.Add(logicOperator) insert = True logicOperator = "" End If Loop While Not insert End If Next i If item.Trim <> "" Then postfix.Add(item.Trim) End If For i As Integer = operatorStack.Count - 1 To 0 Step -1 postfix.Add(operatorStack(i)) operatorStack.RemoveAt(i) Next For i As Integer = 0 To postfix.Count - 1 If postfix(i).ToString <> "<" And postfix(i).ToString <> "<=" And postfix(i).ToString <> ">" And postfix(i).ToString <> ">=" _ And postfix(i).ToString <> "==" And postfix(i).ToString <> "!=" And postfix(i).ToString <> "!" And postfix(i).ToString <> "&" _ And postfix(i).ToString <> "|" And postfix(i).ToString <> "" And postfix(i).ToString.ToLower <> "true" And postfix(i).ToString.ToLower <> "false" Then postfix(i) = evaluate(postfix(i).ToString).ToString End If Next Dim elem1 As Object = Nothing Dim pos1 As Integer = 0 Dim elem2 As Object = Nothing Dim pos2 As Integer = 0 Do For i As Integer = 0 To postfix.Count - 1 Select Case postfix(i) Case "<", ">", "<=", ">=", "!=", "==", "&", "|" elem1 = evaluateLogicExpression(elem2, elem1, postfix(i)) postfix(pos1) = elem1.ToString postfix.RemoveAt(pos2) postfix.RemoveAt(i - 1) Exit For Case "!" elem1 = evaluateLogicExpression(elem2, elem1, postfix(i)) postfix(pos1) = elem1.ToString postfix.RemoveAt(i) Exit For Case Else elem2 = elem1 pos2 = pos1 elem1 = CObj(postfix(i)) pos1 = i End Select Next Loop While postfix.Count > 1 If CBool(postfix(0)) Then Return trueValue Else Return falseValue End If Catch 'MsgBox("Invalid expression") Throw New Exception("Invalid Expression") Return "" End Try End Function Function evaluateLogicExpression(ByVal val1 As Object, ByVal val2 As Object, ByVal logicOperator As String) As Boolean ' Created by Jorge Gaona ' 6/8/2007 Try Select Case logicOperator Case "<" Return CDbl(val1) < CDbl(val2) Case ">" Return CDbl(val1) > CDbl(val2) Case "<=" Return CDbl(val1) <= CDbl(val2) Case ">=" Return CDbl(val1) >= CDbl(val2) Case "!" Return Not CBool(val2) Case "!=" Return Not val1.Equals(val2) Case "==" Return val1.Equals(val2) Case "&" Return CBool(val1) And CBool(val2) Case "|" Return CBool(val1) Or CBool(val2) Case Else Return False End Select Catch 'MsgBox("Invalid expression") Throw New Exception("Invalid Expression") End Try End Function Function getLogicOperatorPrecedence(ByVal logicOperator As String) As Integer ' Created by Jorge Gaona ' 6/8/2007 Select Case logicOperator Case "<", ">", "==", "!=", "<=", ">=" Return 3 Case "]" Return 5 Case "&" Return 2 Case "|" Return 1 Case "!" Return 4 Case "[" Return 0 Case Else Return 0 End Select End Function Private Function calc_op(ByVal op As eeSymbol, ByVal operand1 As Double, Optional ByVal operand2 As Double = Nothing) As Double
Select Case op.Token.ToLower Case "&" ' sample to show addition of custom operator Return 5 Case "^" Return (operand1 ^ operand2) Case "+" Select Case op.PrecedenceLevel Case PRECEDENCE.LEVEL1 Return (operand2 + operand1) Case PRECEDENCE.LEVEL4 Return operand1 End Select Case "-" Select Case op.PrecedenceLevel Case PRECEDENCE.LEVEL1 Return (operand1 - operand2) Case PRECEDENCE.LEVEL4 Return -1 * operand1 End Select
Case "*" Return (operand2 * operand1) Case "/" Return (operand1 / operand2) Case "\" Return (CLng(operand1) \ CLng(operand2)) Case "%" Return (operand1 Mod operand2) Case "!" Dim i As Integer Dim res As Double = 1 If operand1 > 1 Then For i = CInt(operand1) To 1 Step -1 res = res * i Next End If Return (res) End Select End Function Private Function calc_function(ByVal func As String, ByVal args As Collection) As Double Select Case func.ToLower Case "cos" Return (Math.Cos(CDbl(args(1)))) Case "sin" Return (Math.Sin(CDbl(args(1)))) Case "tan" Return (Math.Tan(CDbl(args(1)))) Case "floor" Return (Math.Floor(CDbl(args(1)))) Case "ceiling" Return (Math.Ceiling(CDbl(args(1)))) Case "max" Return (Math.Max(CDbl(args(1)), CDbl(args(2)))) Case "min" Return (Math.Min(CDbl(args(1)), CDbl(args(2)))) Case "arcsin" Return (Math.Asin(CDbl(args(1))))
Case "arccos" Return (Math.Acos(CDbl(args(1)))) Case "arctan" Return (Math.Atan(CDbl(args(1))))
Case "sqrt" Return (Math.Sqrt(CDbl(args(1)))) Case "log" Return (Math.Log10(CDbl(args(1))))
Case "log10" Return (Math.Log10(CDbl(args(1))))
Case "abs" Return (Math.Abs(CDbl(args(1))))
Case "round" Return (Math.Round(CDbl(args(1)))) Case "ln" Return (Math.Log(CDbl(args(1)))) Case "neg" Return (-1 * CDbl(args(1))) Case "pos" Return (+1 * CDbl(args(1))) End Select End Function Private Function identifier(ByVal token As String) As Double Select Case token.ToLower Case "e" Return Math.E Case "pi" Return Math.PI Case Else ' look in symbol table....? End Select End Function Private Function is_operator(ByVal token As String, Optional ByVal level As PRECEDENCE = CType(-1, PRECEDENCE), Optional ByRef [operator] As eeSymbol = Nothing) As Boolean Try Dim op As New eeSymbol() op.Token = token op.PrecedenceLevel = level op.tag = "test" Dim ir As Integer = m_operators.BinarySearch(op, op) If ir > -1 Then [operator] = CType(m_operators(ir), eeSymbol) Return True End If Return False Catch Return False End Try End Function Private Function is_function(ByVal token As String) As Boolean Try Dim lr As Integer = Array.BinarySearch(m_funcs, token.ToLower) Return (lr > -1) Catch Return False End Try End Function
Public Function calc_scan(ByVal line As String, ByRef symbols As Queue) As Boolean Dim sp As Integer ' start position marker Dim cp As Integer ' current position marker Dim col As Integer ' input column Dim lex_state As Integer 'Dim cls As TOKENCLASS Dim cc As Char Dim token As String symbols = New Queue() line = line & " " ' add a space as an end marker sp = 0 cp = 0 lex_state = 1
Do While cp <= line.Length - 1 cc = line.Chars(cp) ' if cc is not found then IndexOf returns -1 giving col = 2. col = m_colstring.IndexOf(cc) + 3 ' set the input column Select Case col Case 2 ' cc wasn't found in the column string If ALPHA.IndexOf(Char.ToUpper(cc)) > 0 Then ' letter column? col = 1 ElseIf DIGITS.IndexOf(Char.ToUpper(cc)) > 0 Then ' number column? col = 2 Else ' everything else is assigned to the punctuation column col = 6 End If Case Is > 5 ' cc was found and is > 5 so must be in operator column col = 7 ' case else ' cc was found - col contains the correct column End Select ' find the new state based on current state and column (determined by input) lex_state = m_State(lex_state - 1, col - 1) Select Case lex_state Case 3 ' function or variable end state ' TODO variables aren't supported but substitution ' could easily be performed here or after ' tokenization Dim sym As New eeSymbol() sym.Token = line.Substring(sp, cp - sp) If is_function(sym.Token) Then sym.Cls = TOKENCLASS.KEYWORD Else sym.Cls = TOKENCLASS.IDENTIFIER End If symbols.Enqueue(sym) lex_state = 1 cp = cp - 1 Case 5 ' number end state Dim sym As New eeSymbol() sym.Token = line.Substring(sp, cp - sp) sym.Cls = TOKENCLASS.NUMBER symbols.Enqueue(sym) lex_state = 1 cp = cp - 1 Case 6 ' punctuation end state Dim sym As New eeSymbol() sym.Token = line.Substring(sp, cp - sp + 1) sym.Cls = TOKENCLASS.PUNCTUATION symbols.Enqueue(sym) lex_state = 1 Case 7 ' operator end state Dim sym As New eeSymbol() sym.Token = line.Substring(sp, cp - sp + 1) sym.Cls = TOKENCLASS.[OPERATOR] symbols.Enqueue(sym) lex_state = 1 End Select cp += 1 If lex_state = 1 Then sp = cp Loop Return True End Function Private Sub init() Dim op As eeSymbol Dim state(,) As Integer = {{2, 4, 1, 1, 4, 6, 7}, _ {2, 3, 3, 3, 3, 3, 3}, _ {1, 1, 1, 1, 1, 1, 1}, _ {2, 4, 5, 5, 4, 5, 5}, _ {1, 1, 1, 1, 1, 1, 1}, _ {1, 1, 1, 1, 1, 1, 1}, _ {1, 1, 1, 1, 1, 1, 1}} init_operators()
m_State = state m_colstring = Chr(9) & " " & ".()" For Each op In m_operators m_colstring = m_colstring & op.Token Next
Array.Sort(m_funcs) m_tokens = New Collection() End Sub
Public Sub New() init() End Sub #Region "Recusrsive Descent Parsing Functions"
Private Function level0(ByRef tokens As Queue) As Double Return level1(tokens) End Function
Private Function level1_prime(ByRef tokens As Queue, ByVal result As Double) As Double Dim symbol, [operator] As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Return result End If ' binary level1 precedence operators....+, - If is_operator(symbol.Token, PRECEDENCE.LEVEL1, [operator]) Then tokens.Dequeue() result = calc_op([operator], result, level2(tokens)) result = level1_prime(tokens, result) End If
Return result End Function Private Function level1(ByRef tokens As Queue) As Double Return level1_prime(tokens, level2(tokens)) End Function Private Function level2(ByRef tokens As Queue) As Double Return level2_prime(tokens, level3(tokens)) End Function Private Function level2_prime(ByRef tokens As Queue, ByVal result As Double) As Double Dim symbol, [operator] As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Return result End If ' binary level2 precedence operators....*, /, \, % If is_operator(symbol.Token, PRECEDENCE.LEVEL2, [operator]) Then tokens.Dequeue() result = calc_op([operator], result, level3(tokens)) result = level2_prime(tokens, result) End If Return result End Function Private Function level3(ByRef tokens As Queue) As Double Return level3_prime(tokens, level4(tokens)) End Function Private Function level3_prime(ByRef tokens As Queue, ByVal result As Double) As Double Dim symbol, [operator] As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Return result End If ' binary level3 precedence operators....^ If is_operator(symbol.Token, PRECEDENCE.LEVEL3, [operator]) Then tokens.Dequeue() result = calc_op([operator], result, level4(tokens)) result = level3_prime(tokens, result) End If
Return result End Function Private Function level4(ByRef tokens As Queue) As Double Return level4_prime(tokens) End Function Private Function level4_prime(ByRef tokens As Queue) As Double Dim symbol, [operator] As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Throw New System.Exception("Invalid expression.") End If ' unary level4 precedence right associative operators.... +, - If is_operator(symbol.Token, PRECEDENCE.LEVEL4, [operator]) Then tokens.Dequeue() Return calc_op([operator], level5(tokens)) Else Return level5(tokens) End If
End Function Private Function level5(ByVal tokens As Queue) As Double Return level5_prime(tokens, level6(tokens)) End Function Private Function level5_prime(ByVal tokens As Queue, ByVal result As Double) As Double Dim symbol, [operator] As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Return result End If ' unary level5 precedence left associative operators.... ! If is_operator(symbol.Token, PRECEDENCE.LEVEL5, [operator]) Then tokens.Dequeue() Return calc_op([operator], result) Else Return result End If End Function Private Function level6(ByRef tokens As Queue) As Double Dim symbol As eeSymbol If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Throw New System.Exception("Invalid expression.") Return 0 End If Dim val As Double
' constants, identifiers, keywords, -> expressions If symbol.Token = "(" Then ' opening paren of new expression tokens.Dequeue() val = level0(tokens) symbol = CType(tokens.Dequeue, eeSymbol) ' closing paren If symbol.Token <> ")" Then Throw New System.Exception("Invalid expression.") Return val Else Select Case symbol.Cls Case TOKENCLASS.IDENTIFIER tokens.Dequeue() Return identifier(symbol.Token) Case TOKENCLASS.KEYWORD tokens.Dequeue() Return calc_function(symbol.Token, arguments(tokens)) Case TOKENCLASS.NUMBER tokens.Dequeue() m_stack.Push(CDbl(symbol.Token)) Return CDbl(symbol.Token) Case Else Throw New System.Exception("Invalid expression.") End Select End If
End Function Private Function arguments(ByVal tokens As Queue) As Collection Dim symbol As eeSymbol Dim args As New Collection() If tokens.Count > 0 Then symbol = CType(tokens.Peek, eeSymbol) Else Throw New System.Exception("Invalid expression.") Return Nothing End If Dim val As Double If symbol.Token = "(" Then tokens.Dequeue() args.Add(level0(tokens)) symbol = CType(tokens.Dequeue, eeSymbol) Do While symbol.Token <> ")" If symbol.Token = "," Then args.Add(level0(tokens)) Else Throw New System.Exception("Invalid expression.") Return Nothing End If symbol = CType(tokens.Dequeue, eeSymbol) Loop Return args Else Throw New System.Exception("Invalid expression.") Return Nothing End If End Function #End Region
End Class End Namespace Pollirrata
|
|
|
|
 |
|
 |
shouldn't it remain in the letter state? that way, word variable ending in a number is still treated in one word? given your state table "variable1" will be parsed as two tokens instead of one
(x-a)(x-b)(x-c)...(x-z)
|
|
|
|
 |
|
 |
I think there is a problem with the evaluation of decimal numbers when the pc 's setting are on "coma" for decimal numbers instead of a "point" like in english.
scalpa
http://www.scalpa.info
|
|
|
|
 |
|
 |
It's because of the m_collstring(initialized in the init() sub) assumes the number decimal separator is a dot '.'. This could be easily fixed by initializing the m_colstring according to your system, ie:
m_colstring = Chr(9) & " " & System.Globalization.NumberFormatInfo.CurrentInfo.NumberDecimalSeparator & "()"
|
|
|
|
 |
|
 |
This expression evaluator is very functional.
Great work!!
Thanks!
Jose
|
|
|
|
 |
|
 |
I agree... simple, functional, comprhensible, implementable. Thumb up!
|
|
|
|
 |
|
 |
I try to use your evaluator to evaluate theese kind of strings : ( 8 * 0.001 ) + ( 5 * 1 ) + ( 5 * 100 ) + ( 5 * 10 ) + ( 1 * 1 000 ) + ( 9 * 0.01 ) + ( 0 * 0.1 ) and i ve got a message telling it's invalid !!!!!!!
I think it's a bug because when i try with a shorter one, it works fine (example : ( 1 * 100 ) + ( 7 * 10 ) + ( 3 * 1 )
quisnam igitur sanus ?
|
|
|
|
 |
|
 |
Problem is the space in your one thousand value.
Should be 1000 not 1 000.
The space makes it think it is dealing with two numbers without an operator, clearly an Invalid Expression.
|
|
|
|
 |
|
 |
I f I m using Math.Round(,0), then it will give the answer of 25.5 to 25 instead of 26. How this problem cann't be saved?
|
|
|
|
 |
|
 |
I dont understand anything to ur code but it works greatly
I needed this to implement a skin motor in my media center: www.mydomotix.com
Thanks again
Olixelle
|
|
|
|
 |
|
 |
I'm having trouble adding a single variable into this code. I need to add an X value into the code which will be known when the code runs, so it will need to be passed as into the function. Please help.
The langauge all programmers know best is profanity.
|
|
|
|
 |
|
 |
I built an interface to this calculator over a year ago that lets you type in variables. You can type in "X" or "Bills" or "Crazy Something" or anything pretty much that isn't a number and it will treat it as a variable unless its a function like sqrt().
Check out PoolwarePack at planet source code. It contains 10 programs, the one you want is called SciONE_Calculator.
|
|
|
|
 |
|
 |
Hi,
Very nice piece of code.
I altered it a bit with the code from the previous posts and changed a few things.
- Bugfixed of previous posts in this forum (Also Globalization support)
- support for EXP.
- Don't allow punctuation, as this is prawn to error.
If you would set CultureInfo to use comma as decimal point an you enter by accident a point in your formula, then the code just skiped the point. So 2*2.5 would result in 50.
Now the code will throw an exception, wich is better IMHO.
- Change in the class and the test Code, to work with exceptions instead of messagebox in Class.
I hope this helps to get to a better solution for everybody.
Hereby the code
Class:
Option Strict On
Imports System.Globalization
Imports System.Threading
Public Class mcCalc
Private Class mcSymbol
Implements IComparer
Public Token As String
Public Cls As mcCalc.TOKENCLASS
Public PrecedenceLevel As PRECEDENCE
Public tag As String
Public Delegate Function compare_function(ByVal x As Object, ByVal y As Object) As Integer
Public Overridable Overloads Function compare(ByVal x As Object, ByVal y As Object) As Integer Implements IComparer.Compare
Dim asym, bsym As mcSymbol
asym = CType(x, mcSymbol)
bsym = CType(y, mcSymbol)
If asym.Token > bsym.Token Then Return 1
If asym.Token < bsym.Token Then Return -1
If asym.PrecedenceLevel = -1 Or bsym.PrecedenceLevel = -1 Then Return 0
If asym.PrecedenceLevel > bsym.PrecedenceLevel Then Return 1
If asym.PrecedenceLevel < bsym.PrecedenceLevel Then Return -1
Return 0
End Function
End Class
Private Enum PRECEDENCE
NONE = 0
LEVEL0 = 1
LEVEL1 = 2
LEVEL2 = 3
LEVEL3 = 4
LEVEL4 = 5
LEVEL5 = 6
End Enum
Private Enum TOKENCLASS
KEYWORD = 1
IDENTIFIER = 2
NUMBER = 3
OPERATOR = 4
PUNCTUATION = 5
End Enum
Private m_tokens As Collection
Private m_State(,) As Integer
Private m_KeyWords() As String
Private m_colstring As String
Private Const ALPHA As String = "_ABCDEFGHIJKLMNOPQRSTUVWXYZ"
Private Const DIGITS As String = "#0123456789"
Private m_funcs() As String = {"sin", "cos", "tan", "arcsin", "arccos", _
"arctan", "sqrt", "max", "min", "floor", _
"ceiling", "log", "log10", "ln", _
"exp", "round", "abs", "neg", "pos"}
Private m_operators As ArrayList
Private m_stack As New Stack()
Private Sub init_operators()
Dim op As mcSymbol
m_operators = New ArrayList()
op = New mcSymbol()
op.Token = "-"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL1
m_operators.Add(op)
op = New mcSymbol()
op.Token = "+"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL1
m_operators.Add(op)
op = New mcSymbol()
op.Token = "*"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL2
m_operators.Add(op)
op = New mcSymbol()
op.Token = "/"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL2
m_operators.Add(op)
op = New mcSymbol()
op.Token = "\"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL2
m_operators.Add(op)
op = New mcSymbol()
op.Token = "%"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL2
m_operators.Add(op)
op = New mcSymbol()
op.Token = "^"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL3
m_operators.Add(op)
op = New mcSymbol()
op.Token = "!"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL5
m_operators.Add(op)
op = New mcSymbol()
op.Token = "&"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL5
m_operators.Add(op)
op = New mcSymbol()
op.Token = "-"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL4
m_operators.Add(op)
op = New mcSymbol()
op.Token = "+"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL4
m_operators.Add(op)
op = New mcSymbol()
op.Token = "("
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL5
m_operators.Add(op)
op = New mcSymbol()
op.Token = ")"
op.Cls = TOKENCLASS.OPERATOR
op.PrecedenceLevel = PRECEDENCE.LEVEL0
m_operators.Add(op)
m_operators.Sort(op)
End Sub
Public Function evaluate(ByVal expression As String) As Double
Dim symbols As Queue
Try
If IsNumeric(expression) Then Return CType(expression, Double)
calc_scan(expression, symbols)
Return level0(symbols)
Catch ex As Exception
Throw New System.Exception(ex.Message)
End Try
End Function
Private Function calc_op(ByVal op As mcSymbol, ByVal operand1 As Double, Optional ByVal operand2 As Double = Nothing) As Double
Select Case op.Token.ToLower
Case "&" ' sample to show addition of custom operator
Return 5
Case "^"
Return (operand1 ^ operand2)
Case "+"
Select Case op.PrecedenceLevel
Case PRECEDENCE.LEVEL1
Return (operand2 + operand1)
Case PRECEDENCE.LEVEL4
Return operand1
End Select
Case "-"
Select Case op.PrecedenceLevel
Case PRECEDENCE.LEVEL1
Return (operand1 - operand2)
Case PRECEDENCE.LEVEL4
Return -1 * operand1
End Select
Case "*"
Return (operand2 * operand1)
Case "/"
Return (operand1 / operand2)
Case "\"
Return (CLng(operand1) \ CLng(operand2))
Case "%"
Return (operand1 Mod operand2)
Case "!"
Dim i As Integer
Dim res As Double = 1
If operand1 > 1 Then
For i = CInt(operand1) To 1 Step -1
res = res * i
Next
End If
Return (res)
End Select
End Function
Private Function calc_function(ByVal func As String, ByVal args As Collection) As Double
Select Case func.ToLower
Case "cos"
Return (Math.Cos(CDbl(args(1))))
Case "sin"
Return (Math.Sin(CDbl(args(1))))
Case "tan"
Return (Math.Tan(CDbl(args(1))))
Case "floor"
Return (Math.Floor(CDbl(args(1))))
Case "ceiling"
Return (Math.Ceiling(CDbl(args(1))))
Case "max"
Return (Math.Max(CDbl(args(1)), CDbl(args(2))))
Case "min"
Return (Math.Min(CDbl(args(1)), CDbl(args(2))))
Case "arcsin"
Return (Math.Asin(CDbl(args(1))))
Case "arccos"
Return (Math.Acos(CDbl(args(1))))
Case "arctan"
Return (Math.Atan(CDbl(args(1))))
Case "sqrt"
Return (Math.Sqrt(CDbl(args(1))))
Case "log"
Return (Math.Log10(CDbl(args(1))))
Case "log10"
Return (Math.Log10(CDbl(args(1))))
Case "abs"
Return (Math.Abs(CDbl(args(1))))
Case "round"
Return (Math.Round(CDbl(args(1))))
Case "ln"
Return (Math.Log(CDbl(args(1))))
Case "exp"
Return (Math.Exp(CDbl(args(1))))
Case "neg"
Return (-1 * CDbl(args(1)))
Case "pos"
Return (+1 * CDbl(args(1)))
End Select
End Function
Private Function identifier(ByVal token As String) As Double
Select Case token.ToLower
Case "e"
Return Math.E
Case "pi"
Return Math.PI
Case Else
' look in symbol table....?
End Select
End Function
Private Function is_operator(ByVal token As String, Optional ByVal level As PRECEDENCE = CType(-1, PRECEDENCE), Optional ByRef operator As mcSymbol = Nothing) As Boolean
Try
Dim op As New mcSymbol()
op.Token = token
op.PrecedenceLevel = level
op.tag = "test"
Dim ir As Integer = m_operators.BinarySearch(op, op)
If ir > -1 Then
operator = CType(m_operators(ir), mcSymbol)
Return True
End If
Return False
Catch
Return False
End Try
End Function
Private Function is_function(ByVal token As String) As Boolean
Try
Dim lr As Integer = Array.BinarySearch(m_funcs, token.ToLower)
Return (lr > -1)
Catch
Return False
End Try
End Function
Public Function calc_scan(ByVal line As String, ByRef symbols As Queue) As Boolean
Dim sp As Integer ' start position marker
Dim cp As Integer ' current position marker
Dim col As Integer ' input column
Dim lex_state As Integer
Dim cls As TOKENCLASS
Dim cc As Char
Dim token As String
symbols = New Queue()
line = line & " " ' add a space as an end marker
sp = 0
cp = 0
lex_state = 1
Do While cp <= line.Length - 1
cc = line.Chars(cp)
' if cc is not found then IndexOf returns -1 giving col = 2.
col = m_colstring.IndexOf(cc) + 3
' set the input column
Select Case col
Case 2 ' cc wasn't found in the column string
If ALPHA.IndexOf(Char.ToUpper(cc)) > 0 Then ' letter column?
col = 1
ElseIf DIGITS.IndexOf(Char.ToUpper(cc)) > 0 Then ' number column?
col = 2
Else ' everything else is assigned to the punctuation column
'col = 6
Throw New System.Exception("Invalid character in expression '" & cc & "'")
End If
Case Is > 5 ' cc was found and is > 5 so must be in operator column
col = 7
' case else ' cc was found - col contains the correct column
End Select
' find the new state based on current state and column (determined by input)
lex_state = m_State(lex_state - 1, col - 1)
Select Case lex_state
Case 3 ' function or variable end state
' TODO variables aren't supported but substitution
' could easily be performed here or after
' tokenization
Dim sym As New mcSymbol()
sym.Token = line.Substring(sp, cp - sp)
If is_function(sym.Token) Then
sym.Cls = TOKENCLASS.KEYWORD
Else
sym.Cls = TOKENCLASS.IDENTIFIER
End If
symbols.Enqueue(sym)
lex_state = 1
cp = cp - 1
Case 5 ' number end state
Dim sym As New mcSymbol()
sym.Token = line.Substring(sp, cp - sp)
sym.Cls = TOKENCLASS.NUMBER
symbols.Enqueue(sym)
lex_state = 1
cp = cp - 1
Case 6 ' punctuation end state
Dim sym As New mcSymbol()
sym.Token = line.Substring(sp, cp - sp + 1)
sym.Cls = TOKENCLASS.PUNCTUATION
symbols.Enqueue(sym)
lex_state = 1
Case 7 ' operator end state
Dim sym As New mcSymbol()
sym.Token = line.Substring(sp, cp - sp + 1)
sym.Cls = TOKENCLASS.OPERATOR
symbols.Enqueue(sym)
lex_state = 1
End Select
cp += 1
If lex_state = 1 Then sp = cp
Loop
Return True
End Function
Private Sub init()
Dim op As mcSymbol
Dim state(,) As Integer = {{2, 4, 1, 1, 4, 6, 7}, _
{2, 2, 3, 3, 3, 3, 3}, _
{1, 1, 1, 1, 1, 1, 1}, _
{2, 4, 5, 5, 4, 5, 5}, _
{1, 1, 1, 1, 1, 1, 1}, _
{1, 1, 1, 1, 1, 1, 1}, _
{1, 1, 1, 1, 1, 1, 1}}
Thread.CurrentThread.CurrentCulture = New CultureInfo("nl-BE")
'Thread.CurrentThread.CurrentCulture = New CultureInfo("en-US")
init_operators()
m_State = state
'm_colstring = Chr(9) & " " & ".()"
m_colstring = Chr(9) + " " + System.Globalization.CultureInfo.CurrentCulture.NumberFormat.CurrencyDecimalSeparator() + "()"
For Each op In m_operators
m_colstring = m_colstring & op.Token
Next
Array.Sort(m_funcs)
m_tokens = New Collection()
End Sub
Public Sub New()
init()
End Sub
#Region "Recusrsive Descent Parsing Functions"
Private Function level0(ByRef tokens As Queue) As Double
Return level1(tokens)
End Function
Private Function level1_prime(ByRef tokens As Queue, ByVal result As Double) As Double
Dim symbol, operator As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Return result
End If
' binary level1 precedence operators....+, -
If is_operator(symbol.Token, PRECEDENCE.LEVEL1, operator) Then
tokens.Dequeue()
result = calc_op(operator, result, level2(tokens))
result = level1_prime(tokens, result)
End If
Return result
End Function
Private Function level1(ByRef tokens As Queue) As Double
Return level1_prime(tokens, level2(tokens))
End Function
Private Function level2(ByRef tokens As Queue) As Double
Return level2_prime(tokens, level3(tokens))
End Function
Private Function level2_prime(ByRef tokens As Queue, ByVal result As Double) As Double
Dim symbol, operator As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Return result
End If
' binary level2 precedence operators....*, /, \, %
If is_operator(symbol.Token, PRECEDENCE.LEVEL2, operator) Then
tokens.Dequeue()
result = calc_op(operator, result, level3(tokens))
result = level2_prime(tokens, result)
End If
Return result
End Function
Private Function level3(ByRef tokens As Queue) As Double
Return level3_prime(tokens, level4(tokens))
End Function
Private Function level3_prime(ByRef tokens As Queue, ByVal result As Double) As Double
Dim symbol, operator As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Return result
End If
' binary level3 precedence operators....^
If is_operator(symbol.Token, PRECEDENCE.LEVEL3, operator) Then
tokens.Dequeue()
result = calc_op(operator, result, level4(tokens))
result = level3_prime(tokens, result)
End If
Return result
End Function
Private Function level4(ByRef tokens As Queue) As Double
Return level4_prime(tokens)
End Function
Private Function level4_prime(ByRef tokens As Queue) As Double
Dim symbol, operator As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Throw New System.Exception("Invalid expression.")
End If
' unary level4 precedence right associative operators.... +, -
If is_operator(symbol.Token, PRECEDENCE.LEVEL4, operator) Then
tokens.Dequeue()
Return calc_op(operator, level5(tokens))
Else
Return level5(tokens)
End If
End Function
Private Function level5(ByVal tokens As Queue) As Double
Return level5_prime(tokens, level6(tokens))
End Function
Private Function level5_prime(ByVal tokens As Queue, ByVal result As Double) As Double
Dim symbol, operator As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Return result
End If
' unary level5 precedence left associative operators.... !
If is_operator(symbol.Token, PRECEDENCE.LEVEL5, operator) Then
tokens.Dequeue()
Return calc_op(operator, result)
Else
Return result
End If
End Function
Private Function level6(ByRef tokens As Queue) As Double
Dim symbol As mcSymbol
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Throw New System.Exception("Invalid expression.")
Return 0
End If
Dim val As Double
' constants, identifiers, keywords, -> expressions
If symbol.Token = "(" Then ' opening paren of new expression
tokens.Dequeue()
val = level0(tokens)
symbol = CType(tokens.Dequeue, mcSymbol)
' closing paren
If symbol.Token <> ")" Then Throw New System.Exception("Invalid expression.")
Return val
Else
Select Case symbol.Cls
Case TOKENCLASS.IDENTIFIER
tokens.Dequeue()
Return identifier(symbol.Token)
Case TOKENCLASS.KEYWORD
tokens.Dequeue()
Return calc_function(symbol.Token, arguments(tokens))
Case TOKENCLASS.NUMBER
tokens.Dequeue()
m_stack.Push(CDbl(symbol.Token))
Return CDbl(symbol.Token)
Case Else
Throw New System.Exception("Invalid expression.")
End Select
End If
End Function
Private Function arguments(ByVal tokens As Queue) As Collection
Dim symbol As mcSymbol
Dim args As New Collection()
If tokens.Count > 0 Then
symbol = CType(tokens.Peek, mcSymbol)
Else
Throw New System.Exception("Invalid expression.")
Return Nothing
End If
Dim val As Double
If symbol.Token = "(" Then
tokens.Dequeue()
args.Add(level0(tokens))
symbol = CType(tokens.Dequeue, mcSymbol)
Do While symbol.Token <> ")"
If symbol.Token = "," Then
args.Add(level0(tokens))
Else
Throw New System.Exception("Invalid expression.")
Return Nothing
End If
symbol = CType(tokens.Dequeue, mcSymbol)
Loop
Return args
Else
Throw New System.Exception("Invalid expression.")
Return Nothing
End If
End Function
#End Region
End Class
Test Code (cmdEvaluate_Click)
Private Sub cmdEvaluate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdEvaluate.Click
Dim calc As New mcCalc()
Try
MsgBox("The answer is " & calc.evaluate(txtExpression.Text), , "Expression Evaluation Test")
Catch ex As Exception
MsgBox("Error " & ex.Message, , "Expression Evaluation Error")
End Try
End Sub
Peter Verijke
|
|
|
|
 |
|
 |
I am trying to extend your parser to give expressions in simplesest exact form in addition to an approximate value. For instance, I want it to give the string "pi" for arcsin(sin(sqrt(ln(e^pi))^2)), and e^pi for arcsin(sin(sqrt(e^pi)^2)). Is there any simple way to do this with lexical scanning. My code is extremely complicated (and unwieldly and large), probobly buggy, and I am stuck on a portion of it. I was wonerering if there was an eaiser way to do this. I also wrote in support for complex numbers (this worked).
|
|
|
|
 |
|