ITE must leave white space?

When using ITE I sometimes want it to return an empty string. However, when leaving the “THEN” field empty, it return a white space (" “) and not blank (”").

I later use the result of this ITE inside a template. If the ITE is at the start or end of the template, these white spaces are easily removed with trim. When the ITE is in the middle, it creates an unneseccery white space. Can we avoid it? Can we remove it after it’s in the template? It’s not always possible to search for double spaces (one from the ITE and another that we left in the template to begin with).

Are you sure?
I just did a quick test, and that’s not what I get (nor is it what I would expect).
Are you 100% sure that the extra whitespace isn’t creeping in somewhere else?
If you can reliably replicate this, I would consider it a bug.

In case you cannot remove it!
Use trim after the ITE and then use it elsewhere!

Thats the easiest bypass!

Well, no :laughing:

Well, no :laughing:

It was my template that was wrong.
What I needed to do is to leave no whitespace between two variables. Then, in those variables, add white space at the start and/or end of the string.

Sorry, only when I reach out to the community do I finally see the error of my ways.


Don’t feel bad, I’ve been there more times than I can count :wink::joy:

1 Like

No problem, I have had this issue before too.

The last one was when I used a Joined List column, by default it puts a comma as separator but if you pay attention what is happening you will see that the separator has an additional space: “, “ (a comma + whitespace”… :face_with_symbols_over_mouth:

Later, if you want to create relations or find items in an array, the results are always empty due to that whitespace.


This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.