473,320 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

CSV Separator

Hello,

I would like to know which CSV separator is set on the machine and I would
like to change it.
Do you have an ideas ?

Thanks
Sébastien
Nov 21 '05 #1
6 6686
Hi,

COMMA Separated Values - can it be other than an comma?

Bernie Yaeger

"Tocnet" <no***********************************@libertysurf .fr> wrote in
message news:d2**********@news.tiscali.fr...
Hello,

I would like to know which CSV separator is set on the machine and I would
like to change it.
Do you have an ideas ?

Thanks
Sébastien

Nov 21 '05 #2
A
Yes I think, because with Win2000, you can set this value with the regional
settings.

Sebastien

"Bernie Yaeger" <be*****@cherwellinc.com> a écrit dans le message de news:
eX**************@TK2MSFTNGP14.phx.gbl...
Hi,

COMMA Separated Values - can it be other than an comma?

Bernie Yaeger

"Tocnet" <no***********************************@libertysurf .fr> wrote in
message news:d2**********@news.tiscali.fr...
Hello,

I would like to know which CSV separator is set on the machine and I
would
like to change it.
Do you have an ideas ?

Thanks
Sébastien


Nov 21 '05 #3
Bernie,

COMMA Separated Values - can it be other than an comma?

Yes it is culture dependend in my country it has to be (official) a
semicolon. Don't forget that the comma is the decimal point in most
languages except English.

Cor
Nov 21 '05 #4
"Tocnet" <no***********************************@libertysurf .fr> schrieb:
I would like to know which CSV separator is set on the machine and I would
like to change it.


'System.Globalization.CultureInfo.CurrentCulture.T extInfo.ListSeparator'
will return the system's list separator string.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #5
Thanks a lot for your help.

Sébastien

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> a écrit dans le
message de news:uR**************@tk2msftngp13.phx.gbl...
"Tocnet" <no***********************************@libertysurf .fr> schrieb:
I would like to know which CSV separator is set on the machine and I would like to change it.


'System.Globalization.CultureInfo.CurrentCulture.T extInfo.ListSeparator'
will return the system's list separator string.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #6
A
Thank you for your response.

Sébastien

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> a écrit dans le
message de news: uR**************@tk2msftngp13.phx.gbl...
"Tocnet" <no***********************************@libertysurf .fr> schrieb:
I would like to know which CSV separator is set on the machine and I
would
like to change it.


'System.Globalization.CultureInfo.CurrentCulture.T extInfo.ListSeparator'
will return the system's list separator string.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

Nov 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Coder Droid | last post by:
After much searching, I can't seem to find any definitive way to determine which path separator to use. Obviously, it's ":" on nix, and ";" on windows ... so what's the best way to determine what...
30
by: Stephen Ferg | last post by:
I have a question that is not directly Python-related. But I thought I'd ask the most erudite group that I know... :-) When did Windows start accepting the forward slash as a path separator...
4
by: Francesco | last post by:
Hi, I've a question... is it possible to change the default separator in the stream operator ">>" (for example from the blank space " " to the comma "," ) ? Here is an example... I want to...
16
by: Douglas | last post by:
Gday, How would I format a number so that: TheValue = 32500 Displays in the TextBox as: $32,500.00
3
by: Carmen Z. | last post by:
do you know how to write a script so that the number that is coming from database with thousand separator (comma) will be eliminated and shown to a web page? so if the value is 1,200, i wanto...
10
by: T.K Kullervo | last post by:
Hi, is there someway to change the regional settings--> numbers--> decimal separator for the the program im creating. I dont want to change it permanently but my program doesnt work if the...
2
by: ari | last post by:
I have a small form that comprises a toolbar, a treeview and a status bar. Everything was working fine until I decided to add a new button to the toolbar - and I decided for appearances sake to...
1
by: AriJayaraman | last post by:
I am having one datagrid in my page where the user will enter some information and that information is saved into database.I am adding separators to my datagrid rows in the pre render event of the...
8
by: Larry Bates | last post by:
I have a project that I wanted to solicit some advice on from this group. I have millions of pages of scanned documents with each page in and individual .JPG file. When the documents were scanned...
0
by: ARC | last post by:
Hello all, I'm a bit stumped on this one. I have a ribbon menu where I am allowing the users to hide main options that they don't use. I use a separator id in between each option to get a...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.