Need to filter out items of list

[Skip Kimpel]

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 <pete at 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 <
> skip at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode