Re: Importing/parsing CSV files
Re: Importing/parsing CSV files
- Subject: Re: Importing/parsing CSV files
- From: Doug McNutt <email@hidden>
- Date: Thu, 7 Sep 2006 08:29:06 -0600
At 09:43 -0400 9/7/06, Mark J. Reed wrote:
>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.
Does anyone have an authoritative reference to the "official" CSV format? An RFC, for instance? The banks are really into CSV. Do they publish a standard?
My experience is that different APPLs and different software houses have the usual different ideas. It's a lot like the RTF "standard" that differs ever more widely between Microsoft and Apple.
For a one-time job, which this seems to be, a look at the actual format in use will probably get a quicker result. A couple of judicious replace statements in a text editor can remove the strange things that occur before processing with regular expressions, be it perl or satimage.
In the sample results the list items are enclosed in quote marks as they would be in AppleScript source code to indicate that the items are type TEXT in the list of constant items. I'm a bit confused about just what an automated procedure should place in the list as it would occur in memory. If the list is created, as a file is read, by successively adding items each of which is TEXT there would be no quotes or commas involved unless they were intended to be part of an individual TEXT item.
--
--> Life begins at ovulation. Ladies should endeavor to get every young life fertilized. <--
_______________________________________________
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