Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Export to csv: configuration

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...
Need Help
  • alanhodgson's avatar
    alanhodgson
    9 years ago

    Hey Anonymous,

     

    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:

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Sasa
    Regular Visitor
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      I have same problem described in this topic.

      Someone has any solution? Maybe PC definitions edditing?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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