Re: Search question

2012-01-31 Thread Bob Sneidar
merge([[artist]][[policeman]]) = A brush with the law Sorry I had to. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

Re: Search question

2012-01-30 Thread Dan Friedman
Marty, I don't know if it's the fastest way, but here's one way to do it. Pass with function your tab-delimited list and what you are looking to find in fields 1,3 and 4 and it will return a list of the lines numbers that match. Hope it helps... function getTheMatches tList,findThis set

Re: Search question

2012-01-30 Thread Ken Corey
How about this: --8- repeat for each line myLine in myList if matchText(myLine, \ ([^\t]*)\t([^\t]*)\t([^\t]*)\t([^\t]*)$, \ myVar1, myVar2, myVar3, myVar4) then if myVar1=foo and myVar3=bar and myVar4=baz then -- take some action here end if

Re: Search question

2012-01-30 Thread Mike Bonner
Or with filter I setup a stack with a list field and 4 search fields, 1 search field for each column, and added a search button. --Search button code on mouseUp put field mylist into tMyList repeat with i = 1 to 4 if field (field i) is empty then put * into line i of tMerge

Re: Search question

2012-01-30 Thread Mike Bonner
oops. Change the merge line to this for partial matches filter tmyList with (merge(*[[line 1 of tMerge]]*[[tab]]*[[line 2 of tMerge]]*[[tab]]*[[line 3 of tMerge]]*[[tab]]*[[line 4 of tMerge]]*)) On Mon, Jan 30, 2012 at 10:57 AM, Mike Bonner bonnm...@gmail.com wrote: Or with filter I

Re: Search question

2012-01-30 Thread Marty Knapp
Thanks to those who responded to this. I was doing something similar to Dan's idea, but wondered if there was a way to use lineOffset or something else. I'll take a look at all the suggestions and continue on. I wish I could wrap my brain around regex - it all looks like a cat walked across my

Re: Search question

2012-01-30 Thread Ken Corey
On 31/01/2012 01:02, Marty Knapp wrote: Thanks to those who responded to this. I was doing something similar to Dan's idea, but wondered if there was a way to use lineOffset or something else. I'll take a look at all the suggestions and continue on. I wish I could wrap my brain around regex - it

Re: Search question

2012-01-30 Thread Ken Corey
On 31/01/2012 01:20, Bob Sneidar wrote: The last time I got into regex, I forgot how to pee. Took two days to get it back. Remind me not to be in the same room when you tackle Objective-C...:^) -Ken ___ use-livecode mailing list

Re: Search question

2012-01-30 Thread Mike Bonner
Huh. I knew I liked merge but didn't know why until now. put merge([[kitty1]][[kitty2]]) into tCatfight On Mon, Jan 30, 2012 at 11:46 PM, Ken Corey k...@kencorey.com wrote: On 31/01/2012 01:02, Marty Knapp wrote: Thanks to those who responded to this. I was doing something similar to Dan's