I'm having an odd behavior with Left(). Consider the following:
Left( "A", 2, " ")
I anticipate the result will be "A " (i.e. padded on the right with a space). And indeed this is what I get.
However, When I use the same expression in a column formula like this:
Left( :Input, 2, " ")
and I have "A" as the value in Input, I am just getting "A" in the result column (i.e. no right space).
Am I missing something?