How to store table data into a text .TXT file using the script?

[mwallman]

Hi all,

How do you store table data into a text .TXT file using the script?

I am aware of Store statement but reading about states it only does qvd and csv files?

I would like to store the data in a text file including the headers.

Anyone know how please?

[sunny_talwar]

Try this:

STORE TableName into File.txt (txt);

[awhitfield]

Or even better:

STORE TableName into File.txt (txt);

[sunny_talwar]

100% much better

UPDATE: Not anymore though

[asgardd2]

Also, you can add custom delimiter, like this:

STORE Transactions into Transactions.txt (txt, delimiter is '|');