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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 >>>> >>>> _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution