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
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 ...
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
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 😉
JackLacava
OneStream Employee
OneStream EmployeeI can't see that feature. Could you post a screenshot please ?
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