[SOLVED]TEXT output format???

Hi,

Is it possible to display the text output format in browser? When the fex runs, it should display the output in text format.

Not WP, FILEDEF test DISK C:/test.txt.

It could be something like

ON TABLE PCHOLD FORMAT TXT.

Any workaround or ideas, please.

Thanks,
Rifaz

This message has been edited. Last edited by: Rifaz,

-Rifaz

WebFOCUS 7.7.x and 8.x

Posts: 406 | Location: India | Registered: June 13, 2013

Twanette

Platinum Member

posted

Hide Post

Hi,
The report output, or just the data?
You could try:

TABLE FILE CAR
PRINT COUNTRY RCOST DCOST
ON TABLE SET STYLEMODE FIXED
END

WebFOCUS 8.2.06 mostly Windows Server

Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008

Ignored post by Twanette posted

Show Post

Twanette

Platinum Member

posted

Hide Post

Or something like:

FILEDEF TESTOUT DISK TESTOUT.TXT
-RUN
TABLE FILE CAR
PRINT COUNTRY RCOST DCOST
COMPUTE BR/A4 = '<br>' ;
ON TABLE HOLD FORMAT ALPHA AS TESTOUT
END
-RUN
-HTMLFORM BEGIN
!IBI.FIL.TESTOUT;
-HTMLFORM END

WebFOCUS 8.2.06 mostly Windows Server

Posts: 195 | Location: Johannesburg, South Africa | Registered: September 13, 2008

Ignored post by Twanette posted

Show Post

Rifaz

Guru

posted

Hide Post

Thanks Twanette for your reply,

Actually, user is going to insert the datas to DB using the text file, i believe.

quote:
TABLE FILE CAR
PRINT COUNTRY AS '' RCOST AS '' DCOST AS ''
ON TABLE SET STYLEMODE FIXED
ON TABLE SET PAGE NOPAGE
END

quote:
FILEDEF TESTOUT DISK TESTOUT.TXT
-RUN
TABLE FILE CAR
PRINT COUNTRY AS '' RCOST AS '' DCOST AS ''
COMPUTE BR/A4 = '
' ;
ON TABLE HOLD FORMAT ALPHA AS TESTOUT
ON TABLE SET PAGE NOPAGE
END
-RUN
-HTMLFORM BEGIN
!IBI.FIL.TESTOUT;
-HTMLFORM END

After saving it as text file in our physical disk, notice there is a little space at the beginning in all the lines which they'd really like to avoid.

Thanks,
Rifaz

This message has been edited. Last edited by: Rifaz,

-Rifaz

WebFOCUS 7.7.x and 8.x

Posts: 406 | Location: India | Registered: June 13, 2013

Ignored post by Rifaz posted

Show Post

Alan B

Virtuoso

posted

Hide Post

Rifaz,
Try:

TABLE FILE CAR
PRINT COUNTRY RCOST DCOST
ON TABLE SAVE  AS FILENAME FORMAT ALPHA
ON TABLE SET PAGE NOPAGE
END
-RUN
SET HTMLFORMTYPE=TXT
-HTMLFORM BEGIN
!IBI.FIL.FILENAME;
-HTMLFORM END
-EXIT

Alan.
WF 7.705/8.007

Posts: 1451 | Location: Portugal | Registered: February 07, 2007

Ignored post by Alan B posted

Show Post

Rifaz

Guru

posted

Hide Post

Ah.. good one. Thanks much Alan