Need to filter out items of list

Peter Haworth pete at lcsql.com
Tue Jun 3 21:59:48 EDT 2014


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
>



More information about the use-livecode mailing list