Filtering Within Lines

[J. Landman Gay]

On 5/27/05 3:45 PM, Gregory Lypny wrote:

> Hello Everyone,
> 
> Is there a regular expression that would make Filter work on items 
> within lines?  What I'm thinking of is a field where a fixed number of 
> items on each line is delimited by tabs; in other words, the field has 
> columns of variables.  If I wanted to search or filter the fourth item 
> specifically, disregarding all other information, I would need a regular 
> expression with three tabs and wild cards.  I tried the following, but 
> it doesn't work.  I suspect my syntax is wrong.
> 
> filter theField with "tab" & "*" & "tab" & "*" & "tab" & "*" & searchPhrase

Does this work?:

filter theField with "*" &tab& "*" &tab& "*" &tab& searchPhrase

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com