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 / 910
909  |  911
Subject: 
Re: CSV delimiters
Newsgroups: 
lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish
Date: 
Sat, 23 Sep 2000 07:25:16 GMT
Reply-To: 
mattdm@mattdm.org#nospam#
Viewed: 
793 times
  
There exists (in CPAN) a Text-CSV perl module. From its documentation:

       This module is based upon a working definition of CSV
       format which may not be the most general.

       1   Allowable characters within a CSV field include 0x09
           (tab) and the inclusive range of 0x20 (space) through
           0x7E (tilde).

       2   A field within CSV may be surrounded by double-quotes.

       3   A field within CSV must be surrounded by double-quotes
           to contain a comma.

       4   A field within CSV must be surrounded by double-quotes
           to contain an embedded double-quote, represented by a
           pair of consecutive double-quotes.

       5   A CSV string may be terminated by 0x0A (line feed) or
           by 0x0D,0x0A (carriage return, line feed).


--
Matthew Miller                     --->                 mattdm@mattdm.org
Quotes 'R' Us                    --->              http://quotes-r-us.org/
Boston University Linux            --->               http://linux.bu.edu/



Message has 1 Reply:
  Re: CSV delimiters
 
(...) Aha! Excellent. Those docs sound well thought out. Hmm, that reminds me... Duh, this is prolly a common Perl thing. I bet Freidl[1] as some stuff on CSV? Lessee... <dig dig dig> Ahh, here we go: pp. 204-208, 227, 231, 290. And (haha!) it even (...) (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 remember looking for this about a year ago, and I came across something that looked very standardish. If I remember right, it's really silly. You don't actually escape things. Fields are comma separated, and optionally surrounded by (...) (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