I have a reqirement , where user want to see the data in txt file as below example with out column header and tab sepated values…
10001 US NYD -6989.23
10003 US SWI 89789.3
10006 IND ABC 242589
10007 UK SWI 89789.3
When ever user exports the Webi Report it shold show in Text file as per the above format.
The current problem im facing is … while i export the report into CSV format its saving in Excel file… i also did 'open file with ’ text its didplaying as
10001 ‘US’ ‘NYD’ -6989.23
10003 ‘US’ ‘SWI’ 89789.3
10006 ‘IND’ ‘ABC’ 242589
10007 ‘UK’ ‘SWI’ 89789.3
text file is giving sigle quotes for Character(string) values… i want to avoid that… report(txt file) shold show as
10001 US NYD -6989.23
10003 US SWI 89789.3
10006 IND ABC 242589
10007 UK SWI 89789.3
Commas with quotes around strings is the “standard” for a csv file (“csv” stands for Comma Separated Values). Because there is limited formatting available for this type of export from Webi, there’s probably no way around this.
You can’t just format the report by creating a variable where everything is put in a single string with tabs between the fields - the csv export from Webi outputs the data set(s) from the queries in the report and NOT the formatted data.
Looking more closely at the scheduling screen, there are some options that may or may not be available to you.
If you’re on BO 3.1 (I’m looking specifically at 3.1 sp5), when you select the csv format for the schedule, scroll down and you’ll have options to set the Text Qualifier - drop-down and select the last entry, which is blank - and the Column Delimiter - set to Tab. To export when viewing the report, select “CSV (with options)” as the export type which will give you the same two settings.
In CSV export options the Text Qualifier is having only 2 option one is " and aniother one is ’ .
Im using BO 4.0
Even im facing the problem is i have only 4 columns in my report, the txt file is not wrapping the line with 4 column , the 5 column also coming from next row…
I’ll need to look at 4.0 - I’m at a client who is still on 3.1. However, in 3.1, the drop-down for Text Qualifier looks like it has only 2 options, but there is a third option, which is blank, at the bottom of the list. So even though it looks like it has only two options, there may actually be three options.
As for the column info - remember that the csv export does not export the report as formatted int the report design. It exports the results of the data provider in the report. So, if you have 5 columns in the query in the data provider, that is what will be exported.
Another thing to think about - Is your BO system running on some flavor of Linux or Unix? BO will export based on the operating system where it’s running. In *nix text files, end of line is a carriage return character. In Windows, it’s a combination of carriage return and line feed. So, text files that are generated on a *nix box may not look right when viewed in Notepad on a Windows box.
(BOB member since 2007-04-16)