Export to csv: configuration

[eddydm]

Hello there,

Is there any possibility to configure the export to csv?

Each time we like to open the csv-file with Excel, we get one column with all the values concatenated.

We have to open a blank sheet in Excel, import the csv-file and tell excel to use a comma as separator, ...

Thanks in advance for any idea.

[eddydm]

@alanhodgson I'm not used to use R-scripting.

I have the impression that your solution has to be develloped for each export i want to do. Correct me if I'm wrong.

(So at this moment i don't think i got an answer. I don't know who has closed this issue by accepting the answer as a solution. I don't know how to reopen this issue.)

I would like to have the possibility that a user can tell to the system that he wants to use tabs instead of , as seperator (and other choices) and that this is working for each export for each visual in the whole report.

Thanks in advance for any information!

Eddy

[Sasa]

Same here. On one PC it is exported as csv in separate columns.

On other PC it exports it all data in one column ( separated by coma).

Any solutions how to solve this problem ,so it exports data in separated columns?

[Anonymous]

Hi,

I have same problem described in this topic.

Someone has any solution? Maybe PC definitions edditing?

[Anonymous]

delimiter of csv is usually preset in system regional settings - Region - Additional settings - Numbers - list separator

[alanhodgson · Accepted solution]

Hey @eddydm,

This can be done with a simple R script. You will need to have R installed and the package "utils".

See my screenshots below:

Script w/ visual:

End Result: