Field separator when exporting to EXcel

[2004 IR Help]

By: marco mistroni - mmarcom

Field separator when exporting to EXcel

2005-12-30 03:45

hello all,

i am having problems with my reports.

I am exportng my reports in Excel format, and i have users from both UK and Denmark.

The problem that i am experiencing is how to set the field delimiter when exporting to Excel..

In UK, field separator is ',' which is understood by Excel so it outputs proper columns.

In denmark, the field separator should be ';'

for some reasons, when exporting my report hte field separator is always the same, ',', so report will looks fine in UK but it won't be undrstood by excel in Denmark.

Can anyone tell me how can i set the field separator dependign on the Locale?

 

thanks in advance and regards

marco