Fill Space in URL
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community.
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.
Thanks!
Solved! Go to Solution.
- Labels:
- Developer Tools
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ZoeM in a formula tool, would something like this work? Replace([YourField]," ","%20")
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I just tried that and it is not working either. And it is affecting my URL by replacing some of the characters once it loads in QVW, strangely.
I have tried removing it to see if my characters return in the URL and they do.
Any other thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you increase the size of the string using a select tool, does the replace([url],' ','%20') option work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
That's an interesting one @ZoeM, i'd have thought the formula @patrick_digan and @OllieClarke put forward would be fine? Could you try and replicate the issue on a subset of your data and attach it?
Regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So...
When I run the workflow the '20' falls off and I remain with only the '%'. So not sure why that is happening?
My main issue is that those blank spaces are splitting my URL and is not being recognized. Oh and this is an xml link, I didn't mention that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I didnt mention that this is an XML link, doe sit make a difference?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Team! I have one half the battle. The power of RegEx worked, the below thread was helpful.
Going to fight the battle now in QVW.
Thanks again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I was facing a similar issue with a hyperlink in an email. Adding double quotes fixed my issue. It did add the quotes in the resulting text, but might try that.
i.e.
"C:\why spaces\" worked for me.
