Selection Set

[Scott Walker]

-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+scottwalker1956=gmail.com at lists.celestial.com]
On Behalf Of Mike Schwartz via Filepro-list
Sent: Tuesday, August 22, 2017 3:29 PM
To: 'Filepro List' <filepro-list at celestial.com>
Subject: RE: Selection Set

> Using a selection set, can you force an exact match
> 
> For example, I want all companies that are named "Ace ".
> 
> If I do a scan on field 1 (company name) I get everyting that starts 
> with
the
> characters "ACE".
> 
> 
> 
> I don't want "Ace Hardware" or "Ace Lumber", I just one the companies 
> that have a field number 1 (Company Name) equal to "ACE ".  Is there a 
> way to get that using a selection set or do you need to use processing
table?
> 
> Regards,
> Scott

    Are you thinking of using  "CO" for contains in the "Rel" field of the
selection set?  

    If you do that, "ACE" will select "Appleton Ace Cleaners".

    Or are you thinking of the "=" (equal sign) that is a wild card
character (matches any character).  If you use "=" you would not fine
"Appleton Ace Cleaners".

Mike Schwartz



Mike, 

I just want to find the company with the name field that is "ACE
".

The content of the field starts with the characters "ACE" and then is
followed by 32 blanks.

Can a scan produce that (and only that ) match or does that have to happen
in processing?

Regards,
Scott





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