Forum Discussion

Martin_Gebhartl's avatar
Martin_Gebhartl
New Contributor III
2 years ago

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 ...
  • 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 😉