I believe in an app where I'm importing data from Excel spreadsheets which were exported as tab-delimited, I run a parseOutQuotes on the data as it is read in (either line-by-line or file-by-file).
Works great, othervise. roymeo At 07:48 PM 5/21/2002 -0700, you wrote: >Hello list, > >i am currently working on a program that will ultimately be a search engine >for media elements. In its final form, i will build a custom interface to >input data, but for the moment, i need to parse data that is easily exported >from Excel. > >Two likely possibilities - CSV or TAB delimited. Some of my data contains >commas, so Excel inherently puts quotes around these elements. I am parsing >this data into a property list. (Thanks to Irv for his article on data cast >members - fit this app perfectly). Two questions: Do I need to check for >quotes around the data before it parses and eliminate them if they exist? >Should I just check the first character and if it is ", then eliminate the >first and last char or is there and easier way? > >Thanks, >--Craig > > >Craig Taylor >Managing Director > >Renegade Digital Media Inc. >30 Summerset Drive >Barrie, ON, L4N 9L7 >C: 416.930.5206 >T: 705.733.1996 | F: 705.733.0503 >E: [EMAIL PROTECTED] > >(digital).video | (interactive).multimedia | (web).solutions >(DVD).authoring | (live_event).media_support > > >[To remove yourself from this list, or to change to digest mode, go to >http://www.penworks.com/lingo-l.cgi To post messages to the list, email >[EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L >is for learning and helping with programming Lingo. Thanks!] ----- Roy Crisman Senior Macromedia Programmer (585)724-4054 [EMAIL PROTECTED] [To remove yourself from this list, or to change to digest mode, go to http://www.penworks.com/lingo-l.cgi To post messages to the list, email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED]). Lingo-L is for learning and helping with programming Lingo. Thanks!]