• 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: Importing/parsing CSV files
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Importing/parsing CSV files


  • Subject: Re: Importing/parsing CSV files
  • From: "Mark J. Reed" <email@hidden>
  • Date: Fri, 8 Sep 2006 09:25:14 -0400

On 9/8/06, Malcolm Fitzgerald <email@hidden> wrote:
each row must have a delimiter

Not if there's only one value in that row.
 

each row must have the same number of columns

Nope.  It's a spreadsheet format.  Different rows can have different numbers of cells.

If the number of columns is less than expected then the next row must
be considered.

Nope.  Newline outside of quotation marks terminates the row always.


The existence of ," or ", in a row demands a corresponding closing quote

...which may be on the next line because of an embedded newline.
 

--
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

  • Follow-Ups:
    • Re: Importing/parsing CSV files
      • From: Malcolm Fitzgerald <email@hidden>
    • Re: Importing/parsing CSV files
      • From: Doug McNutt <email@hidden>
References: 
 >Importing/parsing CSV files (From: T&B <email@hidden>)
 >Re: Importing/parsing CSV files (From: "Mark J. Reed" <email@hidden>)
 >Re: Importing/parsing CSV files (From: T&B <email@hidden>)
 >Re: Importing/parsing CSV files (From: Malcolm Fitzgerald <email@hidden>)

  • Prev by Date: scripting Apple mail text
  • Next by Date: Extract from QuarkXPress
  • Previous by thread: Re: Importing/parsing CSV files
  • Next by thread: Re: Importing/parsing CSV files
  • Index(es):
    • Date
    • Thread