# Substitute or remove text from a string
**URL:** https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009
**Category:** Ask for Help
**Created:** [August 5, 2022, 11:53am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009 "2022-08-05T11:53:43Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 5, 2022, 11:53am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/1 "2022-08-05T11:53:43Z")
Let’s say I have this string :
a,b,c,d
How can I remove “,c” from the string in a Glidetable column ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 5, 2022, 12:08pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/2 "2022-08-05T12:08:01Z")
You can do that with a template column. You just use your string as the source and replace `,c` with nothing.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [August 5, 2022, 12:09pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/3 "2022-08-05T12:09:16Z")
Hi @Ovi,
**Edit : Saw now that Darren replied! 🤦♂️**
If it’s not changing and only **,c** then you can use a Template column. - **like Darren mentioned!**
If it should be dynamic you can do something like this : [remove a value from a string.mp4 - Google Drive](https://drive.google.com/file/d/1SGCzEXLUnrGyLq-YFJKUsNF-CCh3KaXR/view?usp=sharing)
Thank you
---
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 5, 2022, 1:02pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/4 "2022-08-05T13:02:51Z")
Thanks … I’m waiting for the video to be displayed in Drive … @Darren_Murphy , the template is not working for me as both the string and the replacement text are found in columns and from what I see in the template option you need te mention by text what to replace … if it will be the other way around, it will solve the problem because I need to look in Column 1 to find the text from Column 2 and replace it with nothing in Column 1
---
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 5, 2022, 1:29pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/5 "2022-08-05T13:29:32Z")
So, I found the solution with
if anyone is looking for this.
But I have another question
Is there a way to remove some custom things let’s say in Column 1 I have a string that can be like this :
,feqsefw - starting with a comma
or
sdsgsg, - ending with a comma
or
dsfsdgf,dfssqgq - 2 commas
Is there a way to search for those situations , even with an excel formula and remove the comma from the front, from the end or from those 2 and have only 1 ?
Thanks.
---
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 5, 2022, 1:30pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/6 "2022-08-05T13:30:48Z")
@Dilon_Perera the video is still processing … in the future it will be awesome if you can use something like Loom or a screenshot …makes it easier and faster … but I appreciate the involvement … Thank you.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [August 5, 2022, 1:48pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/7 "2022-08-05T13:48:37Z")
I’m sorry! Check again! : [remove a value from a string.mp4 on Vimeo](https://vimeo.com/736864721)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 5, 2022, 1:49pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/8 "2022-08-05T13:49:51Z")
> [@Ovi](#):
>
> the template is not working for me
A template works fine based on how you originally posed the question 😉
> [@Ovi](#):
>
> Is there a way to remove some custom things let’s say in Column 1 I have a string that can be like this :
> ,feqsefw - starting with a comma
> or
> sdsgsg, - ending with a comma
> or
> dsfsdgf,dfssqgq - 2 commas
This is not clear to me. For each of the above three cases, what would the expected result be?
By the way, I only see one comma in your 3rd example.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [August 5, 2022, 1:53pm UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/9 "2022-08-05T13:53:13Z")
> [@Ovi](#):
>
> But I have another question
> Is there a way to remove some custom things let’s say in Column 1 I have a string that can be like this :
> ,feqsefw - starting with a comma
> or
> sdsgsg, - ending with a comma
> or
> dsfsdgf,dfssqgq - 2 commas
>
> Is there a way to search for those situations , even with an excel formula and remove the comma from the front, from the end or from those 2 and have only 1 ?
>
> Thanks.
I think the easiest way would be using a Split text column and a Joint text column!
Or maybe some JavaScript!
> **JS**
>
> ```auto
> var string = p1;
> return string.replace(/^[,\s]+|[,\s]+$/g, '').replace(/,[,\s]*,/g, ',');
>
> ```
---
### Author:  [@resepsionis\_ganteng](https://community.glideapps.com/u/resepsionis_ganteng)
#### Post date: [August 6, 2022, 1:18am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/10 "2022-08-06T01:18:50Z")
# Use the type template, the fastest solution. 😆
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 6, 2022, 1:23am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/11 "2022-08-06T01:23:08Z")
> [@Ovi](#):
>
> the template is not working for me as both the string and the replacement text are found in columns and from what I see in the template option
So your replacement values are calculated, not static?
Can you explain further about what you’re trying to do?
---
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 6, 2022, 3:54am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/12 "2022-08-06T03:54:13Z")
> [@Darren\_Murphy](#):
>
> A template works fine based
I use it in a lot of columns but for what I wanted to achieve here it didn’t work, but the solution I posted worked like a charm … could be the question but anyway … we have 2 solutions now :))
Thanks
> [@Darren\_Murphy](#):
>
> This is not clear to me. For each of the above three cases, what would the expected result be?
> By the way, I only see one comma in your 3rd example.
It has 2 commas but they aren’t displayed … don’t know why 🙄
So, in Col1 I have a string that I wanted to be removed from a list of strings in Col2 separated by commas, and also to remove the comma if the value from Col1 is in Col2 with a comma in front.
After picking my brain I ended up with this solution:
I creat an array from Col 2 in Col 3 , I check the value from Col1 in Col3 and get the index, I create another Col4 with the value in Col1 with a comma in front and this action
If Value from Col1 is in Co3 with an index \>=1 then I remove the value that is in Col4 , if the index is 0 that means it’s just the first value and I remove it without a comma in front , which means the original value from Col1.
Hope it makes sense for all, but it worked for me.
---
### Author:  [@Ovi](https://community.glideapps.com/u/Ovi)
#### Post date: [August 6, 2022, 3:56am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/13 "2022-08-06T03:56:50Z")
@Dilon_Perera that’s actually a great way to do it … and similar to what I achieved … Thank you.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [August 6, 2022, 4:08am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/14 "2022-08-06T04:08:37Z")
> [@Ovi](#):
>
> So, in Col1 I have a string that I wanted to be removed from a list of strings in Col2 separated by commas, and also to remove the comma if the value from Col1 is in Col2 with a comma in front.
Okay.
I haven’t looked at what Dilon did, but based on that description I would probably just create an array from the first column (using Split text), and then use the [Remove Element from Array](https://www.glideapps.com/plugins/remove-from) plugin to remove the string. This would return an array, so a joined list column would then be needed to convert it back into a list.
So something like this:
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [August 6, 2022, 6:22am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/15 "2022-08-06T06:22:57Z")
Now I believe Telepathy a lot! 💪 🫣
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [August 7, 2022, 6:23am UTC](https://community.glideapps.com/t/substitute-or-remove-text-from-a-string/46009/16 "2022-08-07T06:23:30Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.