The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Martin_Gebhartl's avatar
Martin_Gebhartl
Contributor
2 years ago
Solved

How to change the delimiter in CSV files created in OS

In OneStream cube views the features to either "Download Results And Save As A CSV File" or to "Download Results And Open" exists. Both features create CSV files with a comma as a delimiter. This is very annoying because when a comma is also used as thousands delimiter, so the CSV File does not get seperated in Excel columns correcty.

Is there the possibility to change the delimiter fpor CSV files?

 

Regards

Martin Gebhartl

Cube View
  • Martin_Gebhartl's avatar
    Martin_Gebhartl
    2 years ago

    Hello Guido,

    we added the the german culture to OneStream and switched the user to the german culture. When I now use the function "download results and save as CSV file" I get a CSV file with semicolon as delimiter!

     

    Regards

    Martin

  • JackLacava's avatar
    JackLacava
    2 years ago

    I see. Yes, as Martin_Gebhartl found out, that separator depends on the .NET culture assigned to the OneStream user (in particular, the .TextInfo.ListSeparator property of Culture objects). US-English uses comma, most European ones use semicolons. Like Martin did, as a workaround Guido_Wams  might want to create a dedicated user with the culture that suits his needs.

    Feel free to file an IdeaStream post if you think this should behave differently 😉

8 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    I can't see that feature. Could you post a screenshot please ?

    • Martin_Gebhartl's avatar
      Martin_Gebhartl
      Contributor
      2 years ago

      Sorry I forgot to give an update. Since we added the german culture (and changed the user to this culture), the csv export (available in the drill down reports) brings semicolons as delimiter!

      Regards

      Martin

  • Guido_Wams's avatar
    Guido_Wams
    New Contributor II
    2 years ago

    Hi Martin,

    I'm facing the same problem. Do you find a solution for it yet?

    Regards,

    Guido Wams

    • Martin_Gebhartl's avatar
      Martin_Gebhartl
      Contributor
      2 years ago

      Hello Guido,

      we added the the german culture to OneStream and switched the user to the german culture. When I now use the function "download results and save as CSV file" I get a CSV file with semicolon as delimiter!

       

      Regards

      Martin

    • JackLacava's avatar
      JackLacava
      Icon for OneStream Employee rankOneStream Employee
      2 years ago

      Hey Guido,

      any chance of a screenshot from you...? I am not sure what you guys are talking about, so I can't help...

      • Martin_Gebhartl's avatar
        Martin_Gebhartl
        Contributor
        2 years ago

        Hello Jack,

        I was writing about these functions in the drill down result report:

        Regards

        Martin