Brackets in csv file generated by BI Broadcaster

[Former Member]

Hi all,

Here is my problem:

I generate a csv file using the BI broadcaster (BI 7.0). It works, but each field of the file are between brackets.

i.e:

"13.11.2008";"63417440";" EDT";"101";"780032";"1452";"8EAE";"1.141,000"

instead of:

13.11.2008;63417440;EDT;101;780032;1452;8EAE;1.141,000

Do you know why? Is there a set-up to avoid these brackets?

Thanks for your help.

Stephane

[Former Member]

Hi,

To my knowledge for example,

take a flat file and then save it in CSV format you can see the text file in the below format as

17,"SR-30","PSO-ABM Wise Ranking Report"

18,"SR-18 (SR-72)","PSO WISE SALES RECORD"

19,"SR-27 ","Ranking Report Percentage Wise"

20,"SR-28","ZM WISE RANKING (RUPEE WISE"

21,"SR-32","RM WISE PRODUCTIVITY RANKING "

22,"SR-11","Field Performance History "

23,"SR-24","SALES TO STOCKIST "

24,"SR-7-Z","MONTHLY ACTUAL UNITS SOLD EXCLUDING BONUS -ZM WISE"

This is the actual format for the CSv file.If you try changing it then you will get an error.

Go to data source->right click on display->go to extraction tab->you can see data format click on it you will get the formats as fixed lenth,CSV

Under that you can see data seperator there csv allow either comma(,) or (

under that you can see escape sign that is (")

these are the actual CSV formats.

Try changing them and give your own format you will get an error.

I hope it will help you.

If the above is wrong correct me.

[rajkumar_kandula]

Hi,

Please go thorugh this thread, it may helps you in Understanding/fixing this issue

[Former Member]

Thank you Raj, but it doesn't answer to my problem...