Spaces are usually represented in URLs as "%20", so your calc would beed to be:
If ( not IsEmpty(clients_CHURCH::PR email Link 2);clients_CHURCH::PR email Link 2 Label&" www.domain.com/PR/" &
Substitute ( clients_CHURCH::PR email Link 2 ; " " ; "%20" )
& "¶¶" ; "" )
I delimited the above so you can see it easier. Use the Substitute() function to replace any spaces in the text string with %20, the URL should now parse correctly.
Have you tried escaping the space with %20 (i.e.: www.domain.com/PR/Endorsement%201.jpg)?
Thanks so much for taking the time to respond. I so appreciate your great explanation.. thank you and it works great.
Have a great weekend.
I had not until I saw this so thanks so much for taking the time to reply. It works great.
There are other URL encodings that you need to worry about too, such as ampersand (&)
It's best to run a sample of your URL through an encoder to see what it should look like.
Here's a good one:
You can chain multiple substitutions in the same substitute() function, IE:
Substitute( LinkText ; [ " " ; "%20" ] ; [ "&" ; "%26" ] )
Here's a complete list of URL encoders as a reference, you may or may not need them all:
Wow thanks so much for this, I have bookmarked it for safe keeping. You have answered my question and given me greater understanding.
Thanks for the extra, I really appreciate it.
So from the chain approach I am guessing one [" ";"%20"] handles one space only. Is this correct?
Substitute() will substitute for ALL instances of the search string in whatever is passed.
So if you pass it "This is the link", it will return "This%20is%20the%20link" to you.
Thank you Mike, you have been a great help.