Re: Using concat-substring function to replace space in URL control

jacinta — Mon, 27 Jan 2014 21:22:41 GMT

Thanks, kapil. However, I tried that already and the translate function only replaces one-to-one, so only the % gets dropped into where the space is.

Re: Using concat-substring function to replace space in URL control

kapil_kjoshi — Mon, 27 Jan 2014 21:15:55 GMT

Hi Jacinta,

Try using Translate function like this: translate(myURL," ","%20"). It would replace all space with %20. Hope it works out.

Using concat-substring function to replace space in URL control

jacinta — Wed, 22 Jan 2014 00:16:18 GMT

I'm having an issue already discussed in numerous posts, but am having a strange result when implementing the often suggested solution and am hoping someone can tell me what I'm doing wrong.

I'm trying to link to a document on our shared drive from within an InfoPath browser form. The link works beautifully when clicked on from directly within the column of the list, but when clicking on it from within the form I get an error that the path cannot be found. The reason clearly is because, when clicking on the link from within the form, the spaces aren't being replaced with %20 as is automatically done in Sharepoint.

I set a rule on the URL field to run when myURL contains " ". Then, I set the value for myURL to:

concat(substring-before(myURL, " "), "%20", substring-after(myURL, " "))

This is working well to replace all the spaces; however, it's replacing the spaces with %2520 rather than %20. I can't figure out where the extra numbers are coming from. Any ideas on what I'm doing wrong are greatly appreciated.

SharePoint Integration

Re: Using concat-substring function to replace space in URL control

Re: Using concat-substring function to replace space in URL control

Using concat-substring function to replace space in URL control