[SOLVED]How to add an option to save the data as a pipe-delimited file ?
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>,
WebFOCUS 8.1.05 Windows 10
November 12, 2015, 09:02 AM
krish
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.
7.1.1 Windows XP HTML
November 12, 2015, 09:04 AM
Tom Flynn
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