Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have published some pivot tables and straight table charts to web. Whenever the users want to export the charts to csv, the delimiter used is comma. The users have also some string fields that contain comma as a value.
Is it possible to change the delimiter while exporting the chart to CSV. If yes, please explain how to do it
P.S: One way to do it is using a macro but I would like to avoid that because we have a lot of charts and few charts are dynamically generated using a a dynamic dimension selector where the user can choose which fields he wants to see in the chart
Regards
Shah
Hi,
Right click the table, choose the Export option from the context menu and select as Save as Type the option Semicolon delimited (*.skv, *.txt) or which ever format you would like to save
The Export action can only export to comma separated values. There are no options to change the delimiter. If you still want to export using a button you'll have to write macro code to do that.
Hope it helps!!
Hi,
in script just do
Store <Table> into Filename.csv (txt) ;
HTH
André Gomes
Hello,
We are not storing the table in the loading script. We want to export a chart that is a combination of different tables
OK