Filter Command

[Eric Chatonet]

Hi Greg,

Just try something like:
Filter it with "*" & companyName
Assuming there are not other items after the company name...
If there are some: Filter it with "*" & companyName & "*"
"*" means only any string (including tabs).

Best Regards from Paris,

Eric Chatonet.

Le 21 nov. 05 à 20:29, Gregory Lypny a écrit :

> Hello Everyone,
>
> 	I'm having a bit of trouble with the Filter command giving me  
> false positives.  I'm picking off company names in a file  
> containing news headlines.  The headlines file has one headline per  
> line, and each line is tab delimited, where the first item is a  
> unique story number and the second is the actual headline.  It  
> looks something like this:
>
> 1	tab	First headline text
> 2	tab	Second headline text
> 3	tab	Third headline text
> ...
>
> My search command is of the form
>
> 	    filter it with "*" & tab & "*" & companyName & "*"
>
> 	This seems to works fine for all my companies except for "TSE 100  
> Index Participation Fund Units".  I'm getting a lot of hits that  
> contain "TSE" (Toronto Stock Exchange) in the headline but not the  
> rest of the name.  This does not happen with other long names or  
> names that have a common proper noun (e.g., Canada Bread gives me  
> four hits all mentioning Canada Bread and none mentioning Canada or  
> Bread alone).
>
> 	Any thoughts?
>
> 		Regards,
>
> 			Greg

----------------------------------------------------------------
So Smart Software

For institutions, companies and associations
Built-to-order applications: management, multimedia, internet, etc.
Windows, Mac OS and Linux... With the French touch

Free plugins and tutorials on my website
----------------------------------------------------------------
Web site        http://www.sosmartsoftware.com/
Email        eric.chatonet at sosmartsoftware.com/
Phone        33 (0)1 43 31 77 62
Mobile        33 (0)6 20 74 50 86
----------------------------------------------------------------