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 keyboard to my poor mind!
Marty K
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 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
else
put field ("field"& i) into line i of tMerge
end if
end repeat
filter tmyList with (merge("[[line 1 of tMerge]][[tab]][[line 2 of
tMerge]][[tab]][[line 3 of tMerge]][[tab]][[line 4 of tMerge]]"))
put tMyList
end mouseUp
Puts an asterisk for empty search fields puts the value for the fields
that should be matched against.
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
