text("001") = decimal(1.0) Expression Builde...

expressions
(Steven Coile) #1

text(“001”) = decimal(1.0)

Expression Builder says this is valid. When tested, the result is Y.

Equals is not equality?

(Steven Coile) #2

“1” = “001” also returns Y!

(Steven Coile) #3

As does text(“1”) = text(“001”).

(Steven Coile) #4

list((“1” = “+001”), (“hello1hello” = “hello+001hello”), ((“hello” & “1” & “hello”) = (“hello” & “+001” & “hello”)))

N , N , N

(Steven Coile) #5

(list(("+1" = “001”), (“hello+1hello” = “hello001hello”), ((“hello” & “+1” & “hello”) = (“hello” & “001” & “hello”)))

N , N , N

(Steven Coile) #6

“1” + “001” complains, “Arithmetic expression ‘(“1”+“001”)’ has inputs of an invalid type ‘Unknown’”, so this interpretation of text as number is more equals magic?

(Steven Coile) #7

Whoa!!!

list((“1” = “001”), (“x1” = “x001”), ((“x” & “1”) = (“x” & “001”)))

Result:

Y , Y , Y

(Steven Coile) #8

list((“1” = “001”), (“hello1” = “hello001”), ((“hello” & “1”) = (“hello” & “001”)))

Y , Y , Y

(Steven Coile) #9

list((“1” = “001”), (“1hello” = “001hello”), ((“1” & “hello”) = (“001” & “hello”)))

Y , Y , Y

(Steven Coile) #10

list((“1” = “001”), (“hello1hello” = “hello001hello”), ((“hello” & “1” & “hello”) = (“hello” & “001” & “hello”)))

Y , Y , Y

(Steven Coile) #11

This, at least, is expected:

list((“1” = “002”), (“hello1hello” = “hello002hello”), ((“hello” & “1” & “hello”) = (“hello” & “002” & “hello”)))

N , N , N

(Steven Coile) #12

Also expected:

list((“1” = “100”), (“hello1hello” = “hello100hello”), ((“hello” & “1” & “hello”) = (“hello” & “100” & “hello”)))

N , N , N

(Steven Coile) #13

Hmmm…

list((“1” = “001.0”), (“hello1hello” = “hello001.0hello”), ((“hello” & “1” & “hello”) = (“hello” & “001.0” & “hello”)))

N , N , N