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