Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shruthisundar
Contributor
Contributor

Double quotes

How to remove extra double quotes from .txt file?

Store command throws error for 'no quotes'.

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

AFAIK it's not possible. The for the store/export used MS library is quite old and not very flexible. This means you need to remove all quotes from your data - maybe replacing the needed delimiter with another char. By many tools you are able to define which char should be used as quote-char if you want to import it there.

Further possible is to adjust (removing/replacing the appropriate chars) the txt-file with various third-party tools.

An alternatively could also be not to store/export the data else to write them with macro:

Export-to-CSV-with-quotation-marks 

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

AFAIK it's not possible. The for the store/export used MS library is quite old and not very flexible. This means you need to remove all quotes from your data - maybe replacing the needed delimiter with another char. By many tools you are able to define which char should be used as quote-char if you want to import it there.

Further possible is to adjust (removing/replacing the appropriate chars) the txt-file with various third-party tools.

An alternatively could also be not to store/export the data else to write them with macro:

Export-to-CSV-with-quotation-marks 

- Marcus

View solution in original post