filter question

[Jim Ault]

Hey, Chris, 

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.

Thanks,
Jim Ault
Las Vegas


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.
> 
> Chris
> 
> 
> 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
>> tMatches
>> end repeat
>> 
>> -- remove the trailing cr
>> delete last char of tMatches
>> 
>> -- display the matching results
>> put tMatches into fld "Results"
>> 
>> Sarah
>> 
>> 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
>>>> the
>>>> 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?
>>>> 
>>>> Thanks,
>>>> Chris
>>>> 
>>>>