topic Re: Ignore delimiter between quote in csv load in QlikView

Ignore delimiter between quote in csv load

bakaunak — Thu, 19 Dec 2019 21:03:57 GMT

Hello, i have following response from a SOAP - POST request (file1.jpg). i cant use the delimiter (,) because this csv have numbers between the quotes who. How can i ignore the (,) inside the quotes?

If i use the "," as a delimiter:

Re: Ignore delimiter between quote in csv load

avinashelite — Fri, 20 Dec 2019 04:19:31 GMT

better way is to change the delimiter from , to other values like | ........

Re: Ignore delimiter between quote in csv load

jonathandienst — Fri, 20 Dec 2019 05:20:55 GMT

Just a guess, but did you try quote "msq"?

Re: Ignore delimiter between quote in csv load

bakaunak — Fri, 20 Dec 2019 12:51:31 GMT

Hello Jontydkpi! Thanks for the help. When i try quote "msq" this happens:

Re: Ignore delimiter between quote in csv load

bakaunak — Fri, 20 Dec 2019 12:53:52 GMT

Hello Avinashelite! Thanks for the help.

I cant change the delimiter, because this is a webservice from my ERP and i need the real time connection 😁

Re: Ignore delimiter between quote in csv load

Brett_Bleess — Thu, 26 Dec 2019 14:24:12 GMT

I suspect you may need to go directly to the ERP system in this case rather than the report on the web is the only thing of which I can think. Below is Help link to all the available Data Connectors we have at this time, there may be another option for you that will work:

https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Home.htm

Sorry I do not have anything better for you.

Regards,
Brett