Focal Point
2 spaces at the beginning of each line when saving in FORMAT WP

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

March 27, 2008, 01:49 AM
Danny-SRL
2 spaces at the beginning of each line when saving in FORMAT WP
For example:
TABLE FILE CAR
HEADING
"SOME TEXT"
SUM SALES
BY COUNTRY
ON TABLE HOLD FORMAT WP
END


If you look at the output file, it has 2 leading spaces on each line. Is there any SET command which prevents that? (I have other solutions which require reading and re-writing the file)


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

March 27, 2008, 08:59 AM
GinnyJakes
Nope. It has been that way forever. There is also carriage control in a WP file. Have you considered another format, like SAVE? Examine your needs for wp and maybe that format can be replaced with another.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
March 27, 2008, 04:38 PM
Waz
The 2 characters in WP format are historical "Print Control" from many years ago for Mainframe, they contain characters that cause a form feed , line feed, etc.

If you need Format WP, I would suggest re-reading the output file with another master file and use it to remove the leading chars.

Format WP historically used to be 132 chars wide, with later releases, this has increased. You will need to know what the width is, for you Master File.

You can use
? FILEDEF
after the hold to find out the record length.

Hope this helps


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!