Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
marksmunich
Creator III
Creator III

export a table to txt format with semicolon delimiter

Hello qlik's,

I would like to export a qvd table with Just 3 fields. After loading the data from qvd, I am using the statement Store Table1 into Table1.txt(TXT); It is exporting successfully, but using comma as delimiter. Is there a way to change the delimiter here.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

According to the help file it's possible to specify a delimiter

Store Table1 into Table1.txt (TXT, delimiter is '\t');      //tab as delimiter


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

According to the help file it's possible to specify a delimiter

Store Table1 into Table1.txt (TXT, delimiter is '\t');      //tab as delimiter


talk is cheap, supply exceeds demand
marksmunich
Creator III
Creator III
Author

Thanks  gysbert Wasseanaar. I thought its only possible to specify when loading the data like :

Load * from 'c:\userfiles\data1.csv' (ansi, txt, delimiter is ',', embedded

labels);

It's working. thanks a lot.

regards

Marks

Anonymous
Not applicable

bang On... solves the issue thanks.