I have a column with certain data. I want to make each rows in that particular column in CAPS. Is there any possibility by using formula or something in Glide Editor? I understand I can achieve it in GSheet, but want to do this in Glide Data Editor.

You could do it with a template column, replacing a with A, b with B, c with C, etc…

I think I failed to understand exactly what I have to do in template column. [image] I want first column in CAPS in second column. Can you help with it? Thanks

hmm, I may have been a bit hasty there. When I responded I was thinking of this :arrow_down_small: [image] Filter visibility by Character Count! Feature Requests I think I got something here. Not the cleanest solution, but not too bad either. Just takes a little math. …

Thank you! Will be waiting for your reply.

What @Darren_Murphy suggested, was just to set the template to point to your first column. Then add a replacement for each letter of the alphabet. The problem here is that Glide requires an existing column as a replacement value. I think the only way to make this work purely in Glide, at the mom…

Thanks for saving my butt there, Jeff :joy:

Hehe, you would have figured it out eventually. I definitely need string manipulation, but it bugs me that I can’t use a custom value as replacement value in a template. What I have done in the past is create a separate empty column just to have the ability to replace something in a template colum…

Thank you @Jeff_Hager , as always for explaining it in detail. I voted for it. [image] Jeff_Hager: Good string manipulation functions, such as Substring, Trim, Pad, Upper, Lower, Proper, etc. I hope Glide come up with this at the earliest, if they really want “Glide Data Editor” only App eve…

Convert All Rows in a particular column in CAPS

Ask for Help

Darren_Murphy March 26, 2021, 10:42am 4

hmm, I may have been a bit hasty there. When I responded I was thinking of this

But, maybe not…
This is yet another example of something that would be trivial with some string manipulation functions.
And of course it’s also trivial with a spreadsheet function.
But in the GDE with the tools we currently have…
I’ll have a play…

1 Like

Topic		Replies	Views
Upper column in Glide Table Ask for Help	2	317	July 27, 2021
Add Text Functions to Template columns, similar to Math calculations Feature Requests	1	610	February 23, 2021
How to: Capitalize letters (up to five max) in a column (w/ Pic) Ask for Help	7	443	June 5, 2023
Concatenate within Glide Ask for Help	7	4374	September 1, 2023
New user questions Ask for Help	40	504	February 23, 2021

Convert All Rows in a particular column in CAPS

Related topics