I have a repeating section that displays an URL on an infopath form built from a list. Currently it displays URL with the spaces in it. I want to replace those spaces with a %20 to make them link correctly. I am currently using the below function to get it correct myURL = concat(substring-before(myURL, " "), "%20", substring-after(myURL, " ")) but unfortunately this doesn't work for links with multiple spaces that need replaced.
"http://google.com/ apples and oranges.aspx"
is changed to
"http://google.com/%20apples and oranges.aspx"
but i need it to be "https://google.com/%20apples%20and%20oranges.aspx."
Help me out in this .Thanks in advance.