Tuesday, March 27, 2012

default delimiter change from comma to semicolon

Is this possible? I now that i can use custom application to do this, but is
it possible to change semicolon as a default delimiter on server.
Thank's in advance.."AG, NLB d.d." wrote:
> Is this possible? I now that i can use custom application to do this, but is
> it possible to change semicolon as a default delimiter on server.
This probably has to do with the default regional setting on the server. For
US formats comma is used as list seperator, but for most EU countires comma
is used as the decimal seperator so they use semicolon as list seperator.
Otherwise you could get into trouble with a list like this:
5,67,34,56,32,09
Is it 5;67;34;56;32;09 or is it 5,67;34,56;32,09 or any other combination.
In regional settings you can change what the seperator character should be.
Perhaps this link will help you:
http://www.adopenstatic.com/faq/systemdateformat.asp|||i'am sorry to mislead you.
I have a problem with exporting data in CSV format, because data includes
commas, so i have to use some other delimeter like semicolon as default
delimiter on server.
Thanks.
"Glenn F. Henriksen" wrote:
> "AG, NLB d.d." wrote:
> > Is this possible? I now that i can use custom application to do this, but is
> > it possible to change semicolon as a default delimiter on server.
> This probably has to do with the default regional setting on the server. For
> US formats comma is used as list seperator, but for most EU countires comma
> is used as the decimal seperator so they use semicolon as list seperator.
> Otherwise you could get into trouble with a list like this:
> 5,67,34,56,32,09
> Is it 5;67;34;56;32;09 or is it 5,67;34,56;32,09 or any other combination.
> In regional settings you can change what the seperator character should be.
> Perhaps this link will help you:
> http://www.adopenstatic.com/faq/systemdateformat.asp
>|||"AG, NLB d.d." wrote:
> I have a problem with exporting data in CSV format, because data includes
> commas, so i have to use some other delimeter like semicolon as default
> delimiter on server.
Okay, I haven't tried this, but I think you could change the list seperator
value in the control panel->regional settings. But you have to do it for the
user that Reporting services is running under. You may have to change the
default user's settings. Make the change on your own account and then try to
set it to the default system value.
Another option is to make sure that your data in enclosed in quotes, like
this:
"35,54","this, is a test", "example.com, example.net"
--
Glenn F. Henriksen
http://www.henriksen.no/

No comments:

Post a Comment