To save the data of the report as a pipe-delimited file i.e. where the data columns are separated by “pipes”

This message has been edited. Last edited by: <Emily McAllister>,

One option i think of is save the report as comma separated file. following that have unix/windows script that will replace comma to Pipe.

Lookup DFIX in the manual or code it with FORMAT ALPHA

Here's an example of creating a hold file from the CAR table using the DFIX format. The first several lines are comments explaining different options. This example creates the hold file, lists the files in the temp directory, then types out the files that are automatically created from the hold command. (this is an example for windows users) ...

-*
-*ON TABLE HOLD FORMAT ...
-*DFIX DELIMITER delim [ENCLOSURE enclose] [HEADER header] [PRESERVESPACE spaces]..delimited file
-*delim: TAB .... to create tab-delimited data
-*delim: characters .... up to 30 characters as delimiters
-*delim: hex-value .... value for non-printable characters
-*enclose: character .... up to four printable characters to enclose the data
-*enclose: '''' .... four single quotes produces a single quote
-*header: NO .... [default] no title line is included
-*header: YES .... a title line with fieldnames is included
-*spaces: NO .... [default] leading and trailing blank spaces are removed from output
-*spaces: YES .... leading and trailing blank spaces are left in output
-*The spaces option was added in 7.7.04
-*From the WebFOCUS Keysheet, around page 59.
-*
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-TYPE +++ CREATE HOLD FILE FROM CAR --> carhold.txt
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-*
FILEDEF CARHOLD DISK carhold.txt
-*
TABLE FILE CAR
PRINT
DEALER_COST
BY COUNTRY
BY CAR
-*ON TABLE HOLD FORMAT DFIX DELIMITER ,
ON TABLE HOLD AS CARHOLD FORMAT DFIX DELIMITER |
-*ON TABLE HOLD AS CARHOLD FORMAT DFIX DELIMITER | HEADER YES
-*ON TABLE HOLD FORMAT DFIX DELIMITER | ENCLOSURE " HEADER YES
END
-RUN
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-TYPE +++ CMD DIR *.* (list all files in temp directory)
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CMD DIR *.*
-RUN
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-TYPE +++ CMD TYPE carhold.mas
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CMD TYPE carhold.mas
-RUN
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-TYPE +++ CMD TYPE carhold.acx
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CMD TYPE carhold.acx
-RUN
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
-TYPE +++ CMD TYPE carhold.txt
-TYPE +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
CMD TYPE carhold.txt
-RUN

Friendly reminder to all.

Read
The
FOCUS
Manual

Its a fountain of information.

Also

Search the forum.

There are many examples and techniques