Solved

How to change the delimiter in CSV files created in OS

Forum|Forum|2 years ago
November 16, 2023
3 replies
0 views

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

Best answer by Martin_Gebhartl

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

J

JackLacava

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

M

Martin_GebhartlAuthor

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

G

Guido_Wams

Hi Martin,

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

Regards,

Guido Wams