| |
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:
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
|
|
|
|
|
|
