Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to TXT without headers

Created a macro to export a SheetObject to txt/csv. I would like to export the object without headerrow. Any suggestions on how i could change the Macro to do so?

Current Macro looks like this:



Sub

set

sObject = ActiveDocument.GetSheetObject("CH67") SR39

sObject.Export

\\filename.txt",";"

End







Sub



2 Replies
hectorgarcia
Partner - Creator III
Partner - Creator III

i am also interested in this solution, many customers define flat files atructured with no headers...

Hector

Not applicable
Author

There is a very simple workaround: cut the headers from the file after the export. For example file data.txt like this :

Product,Region,Value
one,a,234
one,b,54
one,c,54
three,a,635
three,b,891


Have a batch file containing

type data.txt | find /V "Product,Region,Value" > noheader.txt


-Alex