March 06, 2007, 12:22 PM
Mark1column titles in txt output
Hey,
I would like to know how to suppress column titles in my exported txt file. When I use:
COLUM1 AS ''
Quote marks come out on the text file as the title for COLUMN1. I've looked through help, but so far I haven't found anything. Thanks!
March 06, 2007, 01:54 PM
Francis MarianiNot sure what you mean. The data in the text (ALPHA) file will not be affected by the AS '' statement.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 06, 2007, 02:30 PM
Danny-SRLMark,
It seems to me that you are writing COLUMN1 AS " instead of COLUMN1 AS '', using a double quote instead of 2 single quotes.
March 06, 2007, 03:41 PM
Mark1The two single quotes together look like a single double quote here in the forum.
The focus code has single quote marks with nothing in between.
The text file comes out like this:
"","","",""
column1data,column2data,column3data,column4data
March 06, 2007, 03:59 PM
Alan BMark
Are you using FORMAT COMT ? This would be normal behaviour as COMT saves column headings in the first line.
Try using FORMAT COM if you don't want column headins.
March 20, 2007, 08:34 AM
Mark1Thank you Alan! This works great!