Parameters in open_url: handling coma (,)

venkat_thota — Sat, 16 Nov 2024 03:06:07 GMT

I used document chaining and used open_url, passed the parameters. everything is working great, except when the parameter has a string and that has a coma symbol (,) in it. Coma is treating as a second value of parameter rather than a whole string. How to handle comma to take it as a single string rather than multiple values.

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01, Val, ue

see the above url, since my value is coming with commas like 'Val, ue', its taking 'Val' as one value and 'ue' as second value and filtering data in wrong way.

Re: Parameters in open_url: handling coma (,)

Brett_Bleess — Tue, 30 Jul 2019 16:24:57 GMT

The only thing that comes to mind is URL encoding the ',' like the following:

Val%2Cue

Best I have, hopefully that may do the trick. For further info on that, try doing a Google search on URL encoding as well.

Here is one link: https://www.w3schools.com/tags/ref_urlencode.asp

Regards,
Brett

topic Re: Parameters in open_url: handling coma (,) in QlikView

Parameters in open_url: handling coma (,)

Re: Parameters in open_url: handling coma (,)