Craig, If it would be of any help, I've a couple of behaviors that let you assign data filters to a tab delimited file. Not quite your need but perhaps of some value? As it sits, you must place a text member containing the data on stage as a sprite. It will then format it all pretty as an HTML table. YOu can then query it via Lingo. It allows for and, or and xor of mulitple filters. The return value is a list of the lines in the text matching your criteria. If you, or anyone else would like it just let me known and I'll email a demo file directly to you. Its an "as is" offer though! ;o)
Regards, Kraig > -----Original Message----- > From: Craig Taylor [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, May 21, 2002 7:49 PM > To: [EMAIL PROTECTED] > Subject: <lingo-l> parsing excel data > > > 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!] > [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!]
