JimAultWins at yahoo.com
Tue Mar 14 13:25:45 CST 2006
I know you probably don't have the time, but I am wondering why Phil's
solution did not work. I use the filter command all the time and Phil had
the correct syntax and useage, as far as I could see.
Mostly just curiosity to find exceptions or tricky problems for future
reference. Surprised it did not work.
On 3/14/06 11:01 AM, "Chris Sheffield" <cmsheffield at gmail.com> wrote:
> Thanks, Sarah. I ended up going with a solution similar to this to
> get the job done. I thought Phil's suggestion would have worked, and
> that's what I was trying to do, but unfortunately it didn't.
> But thanks to all who responded.
> On Mar 13, 2006, at 5:08 PM, Sarah Reichelt wrote:
>> It might be faster to filter the list simply to reduce it to lines
>> that contain the filter string anywhere, and then do a loop to check
>> if the filter string is in the correct item.
>> -- gather the original data and the required settings
>> put fld "List" into tList
>> put fld "Filter into Filter
>> put 3 into tItemNum
>> -- do the first filter to reduce the list
>> filter tList with "*" & tFilter & "*"
>> -- loop through making sure it appears in the right item
>> put empty into tMatches
>> repeat for each line L in tList
>> if item tItemNum of L contains tFilter then put L & cr after
>> end repeat
>> -- remove the trailing cr
>> delete last char of tMatches
>> -- display the matching results
>> put tMatches into fld "Results"
>> On 3/14/06, Phil Davis <davis.phil at comcast.net> wrote:
>>> Hi Chris,
>>> To filter on column 3, are you using something like this?
>>> put fld "list" into tList
>>> filter tList \
>>> with "*" & tab & "*" & tab & fld "filter" & tab & "*"
>>> put tList into fld "list"
>>> Phil Davis
>>> Chris Sheffield wrote:
>>>> I'm trying to apply a filter to a list field. The columns of
>>>> the field
>>>> are tab delimited. I have a separate "filter" field that allows
>>>> user to apply a filter to the list based on whichever column is the
>>>> current sort column. I can get the filter to work fine so long
>>>> as the
>>>> first column is selected, but anything else does not work.
>>>> How can I apply a filter to a list based on say item 3 of each
>>>> line of
>>>> that list? Is that possible?
More information about the use-livecode