# How to Url Encode text using the data editor
**URL:** https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602
**Category:** Ask for Help
**Created:** [December 9, 2022, 2:41pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602 "2022-12-09T14:41:02Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [December 9, 2022, 2:41pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/1 "2022-12-09T14:41:02Z")
I can url encode text using the construct url column. But i have to add the protocol and the domain to the front of that text.
The problem is that i need to encode multiple sections of text that get joined together with the & symbol in between. (and various other symbols that i don’t want url encoded)
Simple eg. the cat sat on the mat & the dog ran off with the spoon
Url Encode: the%20cat%20sat%20on%20the%20mat%20%26%20the%20dog%20ran%20off%20with%20the%20spoon
But i need the & symbol to remain behind not turn into %26
I can easily encode (the cat sat on the mat) using Construct Url column BUT then i always get for example [https://domain.com/pathname?pathname=](https://domain.com/pathname?pathname=) added to it
eg. [https://domain.com/pathname?pathname=the%20cat%20sat%20on%20the%20mat](https://domain.com/pathname?pathname=the%20cat%20sat%20on%20the%20mat) (i called my pathname… pathname so thats why that’s there)
So now i have strip everything up to and including the = and replace with nothing/blank.
This is easy with sheets but does anyone have some tricks using glide tables/editor.
I’m using Get Part of URL and the Replace All column but must use a new replace all column for each word or character that i need replaced, super tedious.
Would appreciate the help👍
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 9, 2022, 2:53pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/2 "2022-12-09T14:53:09Z")
> **[Glide • Encode Text column](https://www.glideapps.com/plugins/encode)**
>
> Encode text in a variety of formats.
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [December 9, 2022, 2:59pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/3 "2022-12-09T14:59:56Z")
I saw that, but i can’t get that to do url encode (%20 etc etc)🤔
Can you explain how.
I couldn’t find any help files for this?
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [December 9, 2022, 3:03pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/4 "2022-12-09T15:03:19Z")
OMG i just figured it out, you just type url in the bottom section (the default is Base64, i think?).
They really need a better explanation for that. I figured that our by chance.
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [December 9, 2022, 3:06pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/5 "2022-12-09T15:06:59Z")
It also doesn’t convert a ! into %21
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 9, 2022, 3:19pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/6 "2022-12-09T15:19:52Z")
I believe that the exclamation mark falls into neither the reserved or unsafe sets of characters, so it wouldn’t normally need to be URL encoded.
---
### Author:  [@ToOFa\_Apps](https://community.glideapps.com/u/ToOFa_Apps)
#### Post date: [December 9, 2022, 3:29pm UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/7 "2022-12-09T15:29:14Z")
Just putting it all together. I’ve been using that plugin for where i needed Base64 coding (because it obviously defaults to base 64) but it’s literally the one thing i couldn’t figure out for my ICS files so i had to use a table connected to a google sheet. So frustrating.
Thanks for the help👍
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [July 4, 2023, 3:09am UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/8 "2023-07-04T03:09:26Z")
Hi,
In the encoding, what do we put for (Base64,url) ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 4, 2023, 3:13am UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/9 "2023-07-04T03:13:33Z")
url
---
### Author:  [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)
#### Post date: [July 4, 2023, 3:14am UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/10 "2023-07-04T03:14:32Z")
which url Darren?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [July 4, 2023, 3:17am UTC](https://community.glideapps.com/t/how-to-url-encode-text-using-the-data-editor/55602/11 "2023-07-04T03:17:39Z")
None. Just the string “url” (assuming that you want it url-encoded and not base64 encoded).
