A bug in Execute()

[Ozirys]

Execute(100^2-96^2)  give 19216 !!!!

and  Execute(100^2+96^2)  give 19216

You have a problem with "+" and "-"....

 

[Nine]

If I remember correctly it is a known issue.  This works :

ConsoleWrite(Execute((100^2) - (96^2)) & @CRLF)

 

[Melba23]

Ozirys,

Nine is quite correct - look in the Help file under <Operators - Precedence> and you will see this:

Although the operator precedence should suffice in most cases, is recommended to use brackets to force the order of evaluation if the result is critical or if the expression is complex.

e.g. (2 + 4) * 10 equals 60.

This is particularly true for the - operator which can be used for both binary subtraction (subtraction of 2 numbers)and unary negation (setting the negative of a value). The use of brackets is highly recommended in this case to prevent confusion.

M23

[Ozirys]

I know, but...

I'm surprised that Excel is able to find the solution WITHOUT "()" and Autoit can't.

Do you think that a UDF file can resolve the problem ?

[ioa747]

ConsoleWrite(Execute((100^2) - (96^2)) & @CRLF) ;784
ConsoleWrite(Execute("(100^2) - (96^2)") & @CRLF) ;784

ConsoleWrite(Execute("100^2" - "96^2") & @CRLF) ;4

ConsoleWrite(Execute(100 * 100 - 96 * 96) & @CRLF) ;784

ConsoleWrite(Execute(100^2 -- 96^2) & @CRLF) ;784
ConsoleWrite(Execute(100^2 -+ 96^2) & @CRLF) ;784
ConsoleWrite(Execute(100^2 +- 96^2) & @CRLF) ;19216

everything works to me

Edited March 22, 2024 by ioa747

[SmOke_N]

47 minutes ago, Ozirys said:

I know, but...

I'm surprised that Excel is able to find the solution WITHOUT "()" and Autoit can't.

Do you think that a UDF file can resolve the problem ?

Probably...

ConsoleWrite( _ExecuteNums("100^2-96^2") & @CRLF)

Func _ExecuteNums($vData)
    Local Const $sRE = "(\d+\h*[\*\\\^]\h*\d+)"
    Return Execute(StringRegExpReplace($vData, $sRE, "\($1\)"))
EndFunc

I didn't exclusively test this... you may want to

[Andreik]

1 hour ago, Ozirys said:

Do you think that a UDF file can resolve the problem ?

Let's write a parser instead of putting two parentheses.

[Melba23]

Ozirys,

The question of the varied operator precedence found in different programming languages was discussed in this thread:

It was after that thread that I added more explnation in the Help file.

M23

[argumentum]

1 hour ago, Ozirys said:

Do you think that a UDF file can resolve the problem ?

22 minutes ago, Andreik said:

Let's write a parser instead of putting two parentheses

I vote +1 for the UDF. Now, in the phrase "Let's write ..", would that mean "Let me ( meaning you ) write ..", because if that is so, then yes, let's do it
( I must confess that my math is barely enough for single digit addition, and just barely )

[Ozirys]

Using this solution solve the problem with "^", but if i want to solve  "4500/20*360" it give 0.625 because it makes "4500/(20*360)"

Before use this function it is necessary to check if the string contain "^"

ConsoleWrite( _ExecuteNums("100^2-96^2") & @CRLF)

Func _ExecuteNums($vData)
    Local Const $sRE = "(\d+\h*[\*\\\^]\h*\d+)"
    Return Execute(StringRegExpReplace($vData, $sRE, "\($1\)"))
EndFunc

[SmOke_N]

So... Like I said, I didn't extensively test it... It makes sense looking at the regular expression pattern that the 20*360 was encased by parenthesis.

Func _ExecuteNums($vData)
    Local Const $sRE = "(\d+\h*[\*/^]\h*\d+)"
    Return Execute(StringRegExpReplace($vData, $sRE, "\($1\)"))
EndFunc

I had the wrong character for divisor in the first one... in the few tests I did they worked.

Edit:
For some reason, my other edit didn't post... this should take care of you coming back in a week saying it doesn't work with numbers/floats/doubles.

Func _ExecuteNums($vData, $vDec = ".")
    ; escape decmal chars
    Local Const $sDecRE = "([\\\.\^\$\|\[|\]\(\)\{\}\*\+\?\#])"
    $vDec = StringRegExpReplace($vDec, $sDecRE, "\\$1")

    Local $sRE = "(\d+[\" & $vDec & "\d]*\h*[\*/^]\h*\d+[\" & $vDec & "\d]*)"
    Return Execute(StringRegExpReplace($vData, $sRE, "\($1\)"))
EndFunc

 

Edited March 27, 2024 by SmOke_N

[Ozirys]

I have tested a new regular expression "(\d+\h*[\\\^]\h*\d+)"

Working good

[SmOke_N]

1 hour ago, Ozirys said:

I have tested a new regular expression "(\d+\h*[\\\^]\h*\d+)"

Working good

Hmm... [\\\^] will only look for back slash and "to the power of" ^ ... both codes I provided in my last post are correct (for all my different testing), but the operator regex is [\*/^]

[Ozirys]

I don't know anything about "regular expression".

I simplified: "(\d+\h*[\^]\h*\d+)"

it works too

[SmOke_N]

8 hours ago, Ozirys said:

I don't know anything about "regular expression".

I simplified: "(\d+\h*[\^]\h*\d+)"

it works too

That works on something like: "18/14*4"?

😲

[jugador]

ConsoleWrite( _ExecuteNums('18/14 * 4') & @CRLF)
ConsoleWrite( _ExecuteNums("100^2-96^2") & @CRLF)

Func _ExecuteNums($vData)
    Return Execute(StringRegExpReplace($vData, '([\d.]+)', '($1)'))
EndFunc

 

Edited April 7, 2024 by jugador

[jchd]

There are other forms of numbers like -1.5e3 for instance.

Also this won't work with 100^2--96^3

It's still unclear how -100^2-.5^-1 is interpreted: (-100)^2 - .5^-1 (as AutoIt = 9998) or -(100^2) - .5^-1 (standard = -10002)