• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: reading (parsing) CSV (or Excel) data
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: reading (parsing) CSV (or Excel) data


  • Subject: Re: reading (parsing) CSV (or Excel) data
  • From: "I. Savant" <email@hidden>
  • Date: Fri, 2 Oct 2009 16:33:44 -0400

On Oct 2, 2009, at 4:19 PM, Alex Kac wrote:

Yes! In any case, I'm sure libcsv is more powerful and correct, but the category there worked for my purposes working with several cloud services.

You need only address quoted fields, line breaks within fields, respect character encodings, and line ending variations (CR/LF/CR+LF). Cocoa handles two of these four automagically (in most cases for character encodings, all cases for line endings). The parsing category on macresearch.org adds the other two.


I'm fascinated by the NSMutableCharacterSet efficiency issue but the category seems to work quickly on impressively-sized files (100,000 records with 100 fields, with reasonably long text in the fields), despite its memory inefficiencies. I'll be giving it a test with Mike's suggested modification to see how much better it runs, though. :-)

--
I.S.


_______________________________________________

Cocoa-dev mailing list (email@hidden)

Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com

Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >Re: reading (parsing) CSV (or Excel) data (From: Greg Guerin <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Colin Howarth <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Mike Abdullah <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: "I. Savant" <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Mike Abdullah <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: "I. Savant" <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: "Adam R. Maxwell" <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Colin Howarth <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Alex Kac <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: "I. Savant" <email@hidden>)
 >Re: reading (parsing) CSV (or Excel) data (From: Alex Kac <email@hidden>)

  • Prev by Date: Re: reading (parsing) CSV (or Excel) data
  • Next by Date: Re: Sleep, NSWorkspaceWillSleepNotification, 30 seconds and the run loop
  • Previous by thread: Re: reading (parsing) CSV (or Excel) data
  • Next by thread: Re: reading (parsing) CSV (or Excel) data
  • Index(es):
    • Date
    • Thread