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 <[email protected]>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 <[email protected]> > > To: How to use LiveCode <[email protected]> > > Subject: Re: New chunks > > Message-ID: > > < > cagdt7ep0pdwcchnhoxcfpxdjgpy4yxq9pnmf0brw73je4vc...@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" <[email protected]> wrote: > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
