Re: Importing/parsing CSV files
Re: Importing/parsing CSV files
- Subject: Re: Importing/parsing CSV files
- From: "Mark J. Reed" <email@hidden>
- Date: Thu, 7 Sep 2006 09:43:52 -0400
I would not advise writing your own CSV parser, unless you just like a challenge for its own sake. The format is surprisingly tricky, with the mixture of quoted and unquoted values, embedded commas, and most especially with the possibility of embedded newlines (which Excel happily outputs). Many popular parsers, like Perl's Text::CSV, fail on such values (though Text::xSV handles them), and the possibility changes the basic parsing model by destroying the one line == one record correspondence.
If there's not already an OSAX or something, I would recommend using AppleScript to control an app that already understands the CSV format, like Excel or AppleWorks or Filemaker etc.
--
Mark J. Reed <
email@hidden>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden