Exact Matches...

[daN baueR]

Top post

if you were to do the search in processing then you could use 

Eq "Diesel       "


Sent using a portable electronic communications device.  Please excuse the brevity of this message and erratic spelling/typing. 

Dan

On Apr 27, 2012, at 3:44 AM, "Stanley - stanlyn-com" <stanley at stanlyn.com> wrote:

> 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
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list