To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.admin.databaseOpen lugnet.admin.database in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Administrative / Database / 905
904  |  906
Subject: 
Re: CSV delimiters
Newsgroups: 
lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish
Date: 
Sat, 23 Sep 2000 06:34:50 GMT
Viewed: 
734 times
  
In lugnet.admin.database, Bram Lambrecht writes:
Todd Lehman writes:
Is there any "official" or "reasonably standardized format" for
CSV (_C_omma _S_eparated _V_alue) data?

Sorry, I can't help.  And I hate the way Excel outputs in plain text.

I hate it too.  IIRC, Excel uses "" instead of \" for an escaped " -- but I
could be wrong.  I just remember hating it once when I looked at it.  :)
One nice thing, though, is that Excel can import tab-delimited text, so that's
it's saving grace.


But since it's 2:30 in the morning, I'll make useless comments.
Sounds like you're working on the question I asked...augh, and I just
entered all the sets manually.  Oh well, I was bored anyway. :P

Actually, I'm just gathering background info.  If I start doing exporting and
importing of CSV or tabsep files, I'll want to do it in a general way that
can handle a variety of types of DB tables, with some sort of common output
library function and some sort of common input dialog-box page.

--Todd



Message has 1 Reply:
  Re: CSV delimiters
 
(...) Eeek -- shame on me -- did I just say "it's" when I meant "its"? Anyway, I forgot to say: The idea of escaping quotes is *bizarre* in the first place. IMHO, there shouldn't *be* any closing double-quote character on a field once it has already (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)

Message is in Reply To:
  RE: CSV delimiters
 
(...) Sorry, I can't help. And I hate the way Excel outputs in plain text. But since it's 2:30 in the morning, I'll make useless comments. Sounds like you're working on the question I asked...augh, and I just entered all the sets manually. Oh well, (...) (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 (Sat 23 Nov 2024)
18 hours ago
Custom Search

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