Exact Matches...

[Stanley - stanlyn-com]

Hi Shane,

> "Sales Ta ="

DID WORK...  Hard to believe...  Where is this documented?  An "EX" relation
would be perfect, as I know that I will probably forget this gem.

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