Exact Matches...

[Shane Gray]

> -----Original Message-----
> From: Stanley - stanlyn-com [mailto:stanley at stanlyn.com]
> Sent: Friday, 27 April 2012 5:44 PM
> To: 'Shane Gray'
> Cc: filepro-list at lists.celestial.com
> Subject: RE: Exact Matches...
>
>
> 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
>

eq "diesel     =" (inserting more spaces before wildcard so wildcard at end
of field)