Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Pipe separated csv file.
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Pipe separated csv file.
 Login/Join
 
Guru
posted
Hi,
I am creating a csv report.Is it possible to generate report with pipe separated data in it? Please suggest.

Thanks.

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


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
You can use:
HOLD AS filename FORMAT DFIX DELIMITER |

See the Language Manual: "How to Create a Delimited Sequential File"


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

 
Posts: 1934 | Location: Tel Aviv, Israel | Registered: March 23, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
Hi,
This will genrate report in pipe separated way directly. Can I generate report in csv format which when opened in notepad display the values in Pip separated format?
Please suggest.

Thanks.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
hi,
I also want to add Header and Footer in CSV report and it should also be present in notepad.
Please help.

Thanks.


WF 8.1.04,Windows 7,
DataBase: Oracle 11g,Output :Excel,PDF,HTML
 
Posts: 281 | Location: India | Registered: April 21, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Have you checked the manual about the DFIX format yet.

There are more options than just setting the delimeter.

http://documentation.informati...g/source/topic94.htm

This has also been talked about on the forum before, you could also use the search function here.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6119 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Pipe separated csv file.

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.