Hi Everyone,

When I tried to generate Text format output file, I am getting below 3 issues :

1) Unable to get direct text format(.Txt). Is there a possible way to get text file directly. As of now i tried using Format as DOC and copying to notepad.(Used - ON TABLE HOLD FORMAT DFIX DELIMITER | but equal spacing between columns data is needed with single space)

2) First 2 bytes (2 columns) of the report are showing blanks and constantly after every data field/column the same blank lines are repeating. Can the blanks at the starting be removed and spacing between columns reduced to one space.

3) After some data the header is repeating( around 100 rows, the headers are repeating). Can the Header displays at staring and duplicates can be removed in the text file.

Below is the sample code used:

TABLE FILE CAR
PRINT
COUNTRY AS ''
CAR AS ''
MODEL AS ''
BODYTYPE AS ''
SEATS AS ''
DEALER_COST AS ''
RETAIL_COST AS ''
SALES AS ''
LENGTH AS ''
WIDTH AS ''
HEIGHT AS ''
WEIGHT AS ''
WHEELBASE AS ''
FUEL_CAP AS ''
BHP AS ''
RPM AS ''
MPG AS ''
ACCEL AS ''
HEADING
"CAR REPORT"
ON TABLE PCHOLD FORMAT DOC
END

Any suggestions would be helpful.

Thanks for the help.

Vijay

This message has been edited. Last edited by: FP Mod Chuck,

Hi Vijay

Welcome to Focal Point, it is a great forum to get answers to your development questions!

Try


ON TABLE PCHOLD FORMAT WP


This message has been edited. Last edited by: FP Mod Chuck,

quote:

WP

Hi Chuck Wolff,

Thanks for your suggestion.

I updated code with ON TABLE PCHOLD FORMAT WP

The report opens as plain text within the web browser. Is it possible to save directly in .Txt format like pdf/Excel

The header is repeating (after 50 rows of data) may be its taking page break I guess, can it be displayed only once?

quote:

1) Unable to get direct text format(.Txt). Is there a possible way to get text file directly. As of now i tried using Format as DOC and copying to notepad.(Used - ON TABLE HOLD FORMAT DFIX DELIMITER | but equal spacing between columns data is needed with single space)

Almost there, use ON TABLE HOLD FORMAT DFIX DELIMITER ' '

To get this into a file with a .txt extension, declare the file first using FILEDEF - either within EDATEMP or directly to the network location using full path within the FILEDEF. Then use ON TABLE HOLD AS [your FILEDEF name] - this is standard code, plenty of examples on the Forum and covered in basic training.

quote:

2) First 2 bytes (2 columns) of the report are showing blanks and constantly after every data field/column the same blank lines are repeating. Can the blanks at the starting be removed and spacing between columns reduced to one space.

See previous response. The problem that you are seeing is because of the outputs that you are trying. Stick with DFIX and check out how to use it within help files.

quote:

3) After some data the header is repeating( around 100 rows, the headers are repeating). Can the Header displays at staring and duplicates can be removed in the text file.

DFIX files do not contain the HEADING as you are expecting(?) The "HEADER YES" (or NO) syntax within DFIX formatting refer to the column titles which you are blanking out.

For repeating header in other formats, this is automatic according to the number of output lines set within the LINES environment option. Default is 66 (I think) but if you want to turn this off then just use "SET LINES = 999999" - must be 6 * 9s for correct syntax.

Some training might help you some of this more basic stuff, is it something you and your employers have considered? If not, it would be of benefit.

T