Martin_Gebhartl
2 years agoNew Contributor III
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 ...
- 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
- 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 😉