I have a rather simple but interesting issue.
I have URLs coming in and some of them have spaces which is causing my output in QlikView to not function for some of the results.
I am wondering if I can fill those spaces with '%20' but the 20 is falling off and just leaving the percent sign and subsequently causing the URL to not work.
Any ideas how I can do this? I have also tried using the '_' but that also messes the URL up.