set selection

[Richard Kreiss]

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