Classic thing today, something that should be very, very simple turned out to be a total pain. Using the Business Objects fat client you can choose any CSV export parameter you wish to use, however on the InfoView interface these options a read-only! This is really silly as the engine to generate the reports is exactly the same.
To get around the problem required a bit of hacking on the underlying InfoView scripts. this is probably not support by Business Objects, but it was a fairly simple change.
All that is needed is to edit two files (why two? well I’ve no idea, but figured it was safer to do both): \scripts\CSVoptions.js and \html\CSVOptionsDialogue.html which are located in the “C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\java\server\work\APAPPBO01.WebApplicationContainerServer\businessobjects\AnalyticalReporting\12\AnalyticalReporting-12.war\viewers\cdz_adv\language\en” folder.
The code change is simple;
arr=separators.split(' ');
becomes
arr=(separators+' |').split(' ');
Note: You’ll need to reboot the server as TomCat will not register the change.. weird…
