New chunks
Peter Haworth
pete at lcsql.com
Sun Mar 16 17:32:13 EDT 2014
If you're not into SQL, probably not worth the learning curve to go down
that path.
To answer your question though, I believe that could be done with the right
database structure but you'd probably have to pre-parse your manuscript
into sentences then load each sentence as a separate row in the database.
It also feels like a regexp could do this without having to worry about
stripping out punctuation. The key is to define exactly what constitutes
a sentence.
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 Sun, Mar 16, 2014 at 5:31 AM, Jim Hurley <jhurley0305 at sbcglobal.net>wrote:
> Hi Pete,
>
> I've never gotten into SQL. Will it search for any or all words in any
> order in a sentence?
>
> Jim
>
>
> > Message: 5
> > Date: Sat, 15 Mar 2014 17:02:20 -0700
> > From: Peter Haworth <pete at lcsql.com>
> > To: How to use LiveCode <use-livecode at lists.runrev.com>
> > Subject: Re: New chunks
> > Message-ID:
> > <
> CAGDT7eP0pdWccHNHoXcFPxdJGPy4YxQ9pNMF0bRw73Je4Vc8zQ at mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > Hi Jim,
> > Have you ever tried the sqlite fts virtual table? It's specifically
> > designed for text searching and is lightening fast. Certainly an extra
> > step load stuff into a sneak but might be worth a look.
> >
> > Pete
> > lcSQL Software
> > On Mar 15, 2014 4:25 PM, "Jim Hurley" <jhurley0305 at sbcglobal.net> wrote:
>
> _______________________________________________
> 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