Exact Matches...

[Stanley - stanlyn-com]

Hi Shane,

> Try using the wildcard (=) character in the value.
> e.g.  eq "Sales Ta ="
> Will match anything starting with "Sales Ta ".

Well, I just found a condition where the = wildcard isn't returning what I
was expected, well actually I do expect what this is returning.  What I was
trying to do was not using a wildcard.  Instead I was trying to do a left to
right side comparison, which has nothing to do with a wildcard query.

So here is the new issue.  I'm trying to find only the recs that exactly
equals "Diesel" and not the records that is "Diesel Fuel".  The = wildcard
gets both which is what I would expect, so is Walters solution of doing a
double test of "eq "Diesel" and ne "Diesel Fuel" 

Thanks, Stanley

 






-----Original Message-----
From: filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com
[mailto:filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com] On
Behalf Of Shane Gray
Sent: Wednesday, April 25, 2012 7:45 PM
To: filepro-list at lists.celestial.com
Subject: RE: Exact Matches...

> -----Original Message-----
> From: filepro-list-bounces+fplist=satsof.com.au at lists.celestial.com
> [mailto:filepro-list-bounces+fplist=satsof.com.au at lists.celestial.com] 
> On Behalf Of Stanley - stanlyn-com
> Sent: Thursday, 26 April 2012 6:58 AM
> To: filepro-list at lists.celestial.com
> Subject: Exact Matches...
> 
> Hi,
> 
> 
> 
> How do you find records via the interface's "2-Scan for Records" that
match
> exactly. That is the right side must match the left side exactly.
> 
> 
> 
> Here is an example:
> 
> 
> 
> The table has 165,000 records where the item # is "Sales Tax" and 
> there
are
> a few records where the value is "Sales Ta".  Every way I've tried, it 
> returns all the "Sales Tax" records and there is hours and hours of 
> wading to do.  I know how to get it via code, but this needs to be 
> user friendly
on
> their interface.  I was hoping to see an "EX" option, like eq, lt, gt, 
> ne, and etc to handle this, but its not here.
> 
> 
> 
> Is there anything like "Set Exact on" that could be used for this?  I 
> hope so.
> 
> 
> 
> Thanks, Stanley
> 

Try using the wildcard (=) character in the value.

e.g.  eq "Sales Ta ="

Will match anything starting with "Sales Ta ".

Regards
Shane.

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list