To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.off-topic.geekOpen lugnet.off-topic.geek in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Off-Topic / Geek / 2077
2076  |  2078
Subject: 
Re: CSV delimiters
Newsgroups: 
lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish
Date: 
Sat, 23 Sep 2000 12:28:21 GMT
Viewed: 
20 times
  
Todd Lehman skrev i meddelandet ...
Is there any "official" or "reasonably standardized format" for CSV (_C_omma
_S_eparated _V_alue) data?

I guess it's pretty obvious, mostly, but how are the delimiter characters
typically encoded (specifically: comma, double-quote, and newline)?



I see in the thread that you've got most of the answers you need, but there is
at least one complication in the Windows world (if you ever get files from
that):

The MS programs (and many others too, as followers) don't use the literal
comma, but the Windows system parameter 'List separator'. This means for me
here in Sweden, where we are using comma for decimal point and semicolon as
list separator, that Excel produces a 'CSV' file with semicolons as
separators, and decimal commas (and sometimes the point as thousands
separator)!!!

This makes a h--l of sending such files between different countries, and
intelligent software ignores the National settings when producing files for
export, always using decimal point, and comma as separator.

"Just"; "my"; "SEK"; "0,02"
--
Anders Isaksson, Sweden
BlockCAD:  http://user.tninet.se/~hbh828t/proglego.htm
Gallery:   http://user.tninet.se/~hbh828t/gallery.htm



Message has 1 Reply:
  Re: CSV delimiters
 
(...) Dang. THAT is a very important piece of info -- thanks! OK... Are there any popular programs out there (on the level of Excel, etc.) which only handle CSV text and don't handle tab-delimited text data? --Todd (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)

Message is in Reply To:
  CSV delimiters
 
Is there any "official" or "reasonably standardized format" for CSV (_C_omma _S_eparated _V_alue) data? I guess it's pretty obvious, mostly, but how are the delimiter characters typically encoded (specifically: comma, double-quote, and newline)? In (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)

12 Messages in This Thread:




Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact

This Message and its Replies on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    
Active threads in Database

 
LUGNET Guide updates (Wed 27 Nov 2024)
10 hours ago
Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR