Hi Pete, Yes, it does relate to the previous post about dumping the data into a DB and then manipulating it from there. That was my initial thought process but I abandoned that concept and decided to deal with the file internally.
Initially I thought that I would not need the data after it been "consumed" but now I am seeing a possible need for it for other purposes. I might just redesign this thing with the database method instead. For now I have things working and it is smooth. Maybe I will rework it this weekend. If the text file that I am using already contains headers in line 1, is there a quick and simple way to create and dump all that data into a mysqlite file? My guess is no but I figure I better ask first before heading down a more complicated path. Thank you everybody for all of your input. SKIP > On Jun 3, 2014, at 9:59 PM, Peter Haworth <p...@lcsql.com> wrote: > > Hi Skip, > If this is related to your earlier post about loading a text file into an > SQL database, it's probably just as easy/fast to load all the data into > your database then delete the rows that have the columns corresponding to > items 9/15 set to empty/greater than zero. > > Pete > lcSQL Software <http://www.lcsql.com> > Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and > SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> > > > On Tue, Jun 3, 2014 at 7:02 AM, Magicgate Software - Skip Kimpel < > s...@magicgate.com> wrote: > >> Good morning coders, >> >> I have a very, very large field that contains some text from a tab >> delimited dataset. Row 1 contains the headers. Here is my dilemma... I >> need to filter out lines where item 9=EMPTY or item 15 is greater than 0. >> >> Any help or guidance? >> >> Thank you! >> >> SKIP >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
