Focal Point
[SOLVED] A question for text file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2047058036

May 16, 2013, 12:02 PM
EdHou
[SOLVED] A question for text file
I am trying to create a text file without heading and title. However, if I use “ON TABLE SAVE FILENAME “TEST.TXT” FORMAT VISDIS, then I always get the first line as blank line and the second line with a single character “S”. How do I get rid the first line which is blank line and the second line which has one character “S” there? I want the real data from the 3rd line appear at the first line. If I am using “ON TABLE SAVE FILENAME “TEST.TXT” without “format”, then I always get 6-digit number in front of the real data for each line.

WebFocus 7.6.11
Windows


TABLE FILE CAR
PRINT
'CAR.COMP.CAR' AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SAVE FILENAME
"TEST.TXT" FORMAT VISDIS
ON TABLE SET HTMLCSS ON

--1st line (I don’t want this line)
S --2nd line (I don’t want this line)
JAGUAR
DATSUN
MASERATI
TOYOTA
AUDI
TRIUMPH
ALFA ROMEO
BMW
PEUGEOT

Thank you.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.0.09
WebFOCUS 7.7.05
DBMS: Oracle 11g
all output (Excel, HTML, PDF)
May 16, 2013, 12:40 PM
Alan B
VISDIS is tab delimited for Visual Discovery. That is what the initial lines are for. If you are not using Visual Discovery trying using format TAB.

The 6 digit number sounds like an AnV field. Try converting to straight An.


Alan.
WF 7.705/8.007
May 16, 2013, 12:41 PM
Danny-SRL
FILEDEF TEST DISK appname/test.txt  
TABLE FILE CAR
PRINT CAR 
ON TABLE SAVE AS TEST
END

This will put your test.txt file in the "appname" application without any headings, titles, blank lines etc.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

May 16, 2013, 04:58 PM
EdHou
If the field is variable, then I will get 6-digit "field length" in front. If the field is fixed length, then your way is working.

Thank you both of you.


WebFOCUS 8.0.09
WebFOCUS 7.7.05
DBMS: Oracle 11g
all output (Excel, HTML, PDF)
May 16, 2013, 05:14 PM
EdHou
SOLVED. Thanks.


WebFOCUS 8.0.09
WebFOCUS 7.7.05
DBMS: Oracle 11g
all output (Excel, HTML, PDF)