Mar 18, 2021 04:17 PM
I need help in writing a formula to remove spaces from a URL.
This specific line of text is already pieced together using a formula:
CONCATENATE(“Potential Partner ApplicationStage 2”,{Auto #},"&organization=",{Organization},"&website=",{Website},"&name=",{Name},"&email=",{Email})
which outputs →
Potential Partner ApplicationStage 2 Bottle (75)&website=http://www.lovebottle.com/&name=Kelly Boslow &email=
However there are spaces within this that need to be removed in order to properly use the link.
Can I get someone to help with this?
Mar 18, 2021 05:56 PM
If you’re trying to create a URL, you should probably be using the ENCODE_URL_COMPONENT
function, which does the URL encoding for you.
Mar 19, 2021 08:57 AM
Sorry that didnt work, it created a confusing URL that didn’t do anything in google.
Mar 19, 2021 11:43 AM
If you just want to substitute spaces with nothing, then you would just use the SUBSTITUTE function like this:
SUBSTITUTE({String of Text}," ","")