Arghh.......Need This Feature - TRIM

So. I have an app live with a customer. They have been reporting issues with missing data. This is not something that I see very often with Glide as it’s pretty robust.

On investigation I see, in the data editor, that some of my relationships based on email address are not working correctly. I scratch my head and, after a LONG period of time, I see that some of the emails (which my users enter) have a space on the front or the end. They therefore do not match for the purpose of a Glide relationship. Hence Arghh.

Don’t worry, I hear you say, just add an array formula in the sheet that trims the email to remove any leading and trailing spaces. Well I used to do that in order to lowercase the email, but Glide made this a case-insensitive match, so I could remove that array formula. Hooray. Except now I need to put it back to remove the spaces. Arghh.

I have really focused to build a complex app with NO array formulas whatsoever, part in preparation for Glide native sheets, part to minimise lag (which they introduce) and part to keep as much logic as possible in Glide.

So. How can I strip the spaces? I need a trim function in the Data Editor. Or the email entry field to remove leading and trailing spaces, or the Glide relationship to ignore leading and trailing spaces when matching emails. Otherwise, I’m back in “array formula” land … Arghh.

Team Glide - feel my pain. Please.


You might be saved by the new feature in staging, Split Text.

I tried it, and it does work.

So I added some space before the email in the Sheet here.


I added a split by a space character.

Then make a relation using that split column to a properly formatted email column.

It works.

I added an EmailBasicRel using the wrongly formatted column and there’s the difference.


Hey @ThinhDinh that looks rather promising. Do you know offhand if the “split” functionality would remove, say, 2 or 3 leading spaces?


Yes it will, because it separates by any space character so the resulting array would contain the right email for you.

1 Like

Well then I thank you, from the depths of my heart, for keeping me “array formula free”. And I await a release date! Cheers @ThinhDinh


You can try that in staging as well to see if it applies to your case, my pleasure to help :wink:

1 Like

Yes I will. Out at the moment but will check later. Cheers.

1 Like

How does the space get in there in the first place? The Email entry will remove leading and trailing spaces.


Ok. Bear with @Mark

Arghh … a have a text entry where I should have an email entry in one form submission and that is allowing the trailing space!


I shall address this immediately, although I’m not sure how to now that the app has real data in it since I don’t think I can change the column type…

But thanks @Mark for correcting me and @ThinhDinh whose time I have wasted …

1 Like

No worries brother, at least I know this would work in case I need it anytime in the future.

1 Like