I dig into something weird:
returns TRUE, mais these two items are blank when I look into it.
When I test the function, here is what I get:
These are identical type fields, both REF relating to the same Slice.
In my opinion, if these two datas are BLANK, then the result when I look for a difference must be FALSE.
I just looked a little further:
ISBLANK() on 1st field gives TRUE
ISBLANK() on 2nd field gives TRUE as well
I just spent a few hours trying to guess where this result may come from, but I didn’t get it.
Cherry on the cake, if I try:
I get TRUE as well
But when one at least of the fields is not empty, I get the correct expected value.
I am currently building an email body template, I tried some workaround to avoid that but none of these work : comparing LEN(), comparing TRIM()…
I’m out of ideas.
Do you have any clue on what us happening ? Am I missing some information ?