Filtering Within Lines

[Gregory Lypny]

Excellent suggestion!  Thank you Malte and Jacqueline.  The only 
modification I made was to put tabs on the right side of searchPhrase 
as well to account for columns that come after the column of interest.  
So, for example, to filter the fourth column of eleven, I have

filter it with "*" & tab & "*" & tab & "*" & tab & "*" & searchPhrase & 
"*" & tab & "*" \
     & tab & "*" & tab & "*" & tab & "*" & tab & "*" & tab & "*" & tab & 
"*"

This makes for speedy searches.

Regards,

	Greg

On May 27, 2005, at 7:52 PM, Malte Brill wrote:

> try adding "*"& before the first tab and &"*" after searchstring. Also
> don´t put tab in quotes. (otherwise it will lokk for a string "tab" and
> not the tabulator.
>
> filter theField with "*"  & tab & "*" & tab & "*" & tab & "*" &
> searchPhrase & "*"