Selection Set

[Bruce Easton]

There might be a better way, but here's how you might get a workable 
solution.

Enter your selection set as:

1 lt ACE                          @
1 ge ACE

(Leave group fields blank to 'and' the two lines.  On the first line, 
put the "@" in the last possible position [30th].)

Note - this would report more than what you're looking for if, for 
instance, you had a record where there were more than 27 blanks between 
"ACE" and then a non-blank character in the field.  Note also that I 
have not tested this for cases where there may be non-standard 
characters stored in the field.

Bruce



On 8/22/17 3:33 PM, Scott Walker via Filepro-list wrote:
> -----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
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus