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