set selection

Bruce Easton bruce at stn.com
Tue Sep 28 09:06:38 PDT 2010


  He got it working, but he had two more tests above those defined with 
the selector
sentence that did not use a group.  When he moved those two tests to the 
bottom,
it worked OK.

Bruce

On 9/28/10 11:56 AM, Richard Kreiss wrote:
> Have you considered using -v selection process?
>
> If this is an indexed field, you can use a - lookup and select to get only
> those items you want.
>
> You could hard code the numbers in or create an array to hold the values
> wanted.
>
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
>
>
>
>
>
>> -----Original Message-----
>> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
>> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
>> Behalf Of scooter6 at gmail.com
>> Sent: Tuesday, September 28, 2010 11:01 AM
>> To: Roger Cornelius
>> Cc: filePro Mailing List
>> Subject: Re: set selection
>>
>>    Thanks for the suggestion Roger - but no joy!
>>
>>    That results in:
>>
>>    *** A filePro Error Has Occurred ***
>>
>>    On File:
>>
>>
>> +A OR +B OR +C
>> ^
>> Selection sentence contains a syntax error at position indicated.
>>
>> I think I had tried this before but I have tried so many combinations I'm
> not
>> sure
>>
>> Any thoughts?
>>
>> Scott
>>
>>
>>
>> On Tue, Sep 28, 2010 at 10:53 AM, Roger Cornelius
>> <rac at custom-mobility.com>wrote:
>>
>>> There may be a simpler way, but I think the following should work:
>>>
>>> +A<some field>  ge 4271
>>> +A<some field>  le 4290
>>> +B<some field>  ge 4945
>>> +B<some field>  le 4956
>>> +C<some field>  eq 5558
>>>
>>> +A OR +B OR +C
>>>
>>>
>>> On 09/28/2010 10:34, scooter6 at gmail.com wrote:
>>>> I'm attempting to put together a set selection that has me a bit
>>>> stumped
>>> -
>>>> I've tried several variations using different things in the Group
>>>> heading but without any success.
>>>>
>>>> Basically, I'm creating an export file from a large file.  This file
>>>> contains a 4 digit number field.
>>>> So, currently I'm trying to get ONLY records that are:
>>>>
>>>> ge 4271
>>>> le 4290
>>>>
>>>> ge 4945
>>>> le 4956
>>>>
>>>> eq 5558
>>>>
>>>> I have tried different forms of A, B&  C and then using a selector
>>> sentence
>>>> A OR B OR C, etc....
>>>>
>>>> Can someone explain how I can accomplish this?
>>>>
>>>> Thanks
>>>>
>>>> Scott Ullmann
>>>> PDM, Inc.
>>>> -------------- next part -------------- An HTML attachment was
>>>> scrubbed...
>>>> URL:
>>> http://mailman.celestial.com/pipermail/filepro-list/attachments/201009
>>> 28/06f2219d/attachment.html
>>>> _______________________________________________
>>>> Filepro-list mailing list
>>>> Filepro-list at lists.celestial.com
>>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>>>
>>> --
>>> Roger Cornelius            rac at custom-mobility.com
>>>
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: http://mailman.celestial.com/pipermail/filepro-
>> list/attachments/20100928/9f50c3ff/attachment.html
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>



More information about the Filepro-list mailing list