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 / 906
905  |  907
Subject: 
Re: CSV delimiters
Newsgroups: 
lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish
Date: 
Sat, 23 Sep 2000 06:37:59 GMT
Viewed: 
756 times
  
In lugnet.admin.database, Todd Lehman writes:
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.

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 been declared a string field by an opening
double-quote.  The only escaping that should happen is on commas, IMHO.  But
"that's not how it's done."  :)

--Todd



Message has 1 Reply:
  RE: CSV delimiters
 
(...) I agree. I was trying to hack an Excel file into some usable html, and those "" made it nearly impossible for me to do search and replaces to get valid html without messing it up in other places. --Bram Bram Lambrecht BXL34@po.cwru.edu (URL) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)

Message is in Reply To:
  Re: CSV delimiters
 
(...) 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. (...) (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