Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
bakaunak
Contributor II
Contributor II

Ignore delimiter between quote in csv load

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?

file1.JPG

 

 

 

 

 

 

 

 

 

 

file2.JPG

 

 

 

 

 

 

 

If i use the "," as a delimiter:

file3.JPG

5 Replies
avinashelite

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
bakaunak
Contributor II
Contributor II
Author

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

file4.JPG

 

file5.JPG

bakaunak
Contributor II
Contributor II
Author

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 😁

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.