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

[Steven_Coile]

text(“001”) = decimal(1.0)

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

Equals is not equality?

[Steven_Coile]

“1” = “001” also returns Y!

[Steven_Coile]

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

[Steven_Coile]

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

N , N , N

[Steven_Coile]

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

N , N , N

[Steven_Coile]

“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]

Whoa!!!

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

Result:

Y , Y , Y

[Steven_Coile]

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

Y , Y , Y

[Steven_Coile]

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

Y , Y , Y

[Steven_Coile]

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

Y , Y , Y

[Steven_Coile]

This, at least, is expected:

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

N , N , N

[Steven_Coile]

Also expected:

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

N , N , N

[Steven_Coile]

Hmmm…

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

N , N , N