Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Storing a TXT file without headers in a script

I'm trying to store a table into a TXT file in a script using Store Table into ..Data\TableName.txt (txt);

However I'm getting all kinds of XML information before the data. Is there any way I can store just the raw data?

4 Replies
michael123
Contributor

Re: Storing a TXT file without headers in a script

Below code stores a CSV-file with headers in QV11. Which version are you on?

******

T2:

Load * Inline [

EventDate,EventTime,EventType,StaffName

28/11/12,07:33:57,In,AB

28/11/12,08:34:57,In,BC

];

STORE T2 INTO C:\temp\test.txt (txt);

******

Re: Storing a TXT file without headers in a script

There's no way to directly use STORE to output to a text file without headers. There are a number of solutions available using either macro's or an external vbs script or tool (e.g. sed). If you search the forums you should be able to find more information.


talk is cheap, supply exceeds demand
Not applicable

Re: Storing a TXT file without headers in a script

Hi Gysbert

Thanks for your help.  I'll abandon that idea and look at a button with a macro attached. Hopefully I'll get somewhere as what I'm trying to do is create a .txt file with one field in it and no headers.

Not applicable

Re: Storing a TXT file without headers in a script

Hi again Gysbert

Found the Export option in the Button properties and set export to records with no formatting of numbers and it works a treat.  Thanks for the heads up!

Community Browser