summary sheets from temp file

[scooter6 at gmail.com]

Here is the 'structure' part of the file that's pertinent

Field 1 = 4,#  is the client number   ' in the examples here, that is 2435,
3194 & 5498  - this is what it should sort on - a new page for each unique
client number
Field 2 = 4,allup  is the account number  'in the examples here, that is
what comes after the "-" 0001, 0002 for client 2435, 0143, 0144, 0145 for
client 3194
Field 3 = 9,allup  is the two fields combined  with a "-" in middle   'i.e.
2435-0001, 2435-0002, 3194-0143, etc

So since the file has the client number in a field already, I have it
sorting on field 1 with a length of 4 - which appears to be okay, since
it's doing what I want it to do, except it's not finding the 'lowest'
account number...otherwise, everything works fine haha



On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <bruce at stn.com> wrote:

> Scott - check the sort screen for this - did you sort on Account Number,
> but only for a length of four?
>
> Bruce
>
> On 7/14/14 2:55 PM, scooter6 at gmail.com wrote:
> > adding 'end' in @sbrk1 had no effect - aa is still equal to ab on all
> > pages
> >
> >
> > On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <bruce at stn.com
> > <mailto:bruce at stn.com>> wrote:
> >
> >     Ah yes, the lack of "end" for @sbrk1 is probably why your aa is being
> >     set to your ab.
> >
> >     Bruce
> >
> >     On 7/14/14 2:33 PM, Kenneth Brody wrote:
> >     > On 7/14/2014 1:57 PM, scooter6 at gmail.com
> >     <mailto:scooter6 at gmail.com> wrote:
> >     >> Ken,
> >     >>
> >     >> Here is what my output processing looks, with sort on client
> >     number (4
> >     >> characters and subtotal) and then full account number
> >     >> Everything works great except the 'starting (lowest)' number -
> >     that is
> >     >> coming out blank
> >     >>
> >     >> :1="":end::gP*P|VW_L&4foSDs:
> >     >> @sbrk1::aa(4,#)=mid(3,"6","4")  'this is the lowest number:
> >     > aa(4,#,g)=mid(3,"6","4") ; end
> >     >
> >     >> @wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:
> >     >> ::lookup cli=client  k=1   i=A -nx:
> >     >> ::ac(30,uplow)=cli(2) ' this grabs the name of the client:
> >     >> ::end:
> >     > [...]
> >     >> Any idea why 'aa' starting number is coming back blank?
> >     > [...]
> >     >
> >     > No ",g" flag.
> >     >
> >
> >
> >     _______________________________________________
> >     Filepro-list mailing list
> >     Filepro-list at lists.celestial.com
> >     <mailto:Filepro-list at lists.celestial.com>
> >     Subscribe/Unsubscribe/Subscription Changes
> >     http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> >
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/c48dae8d/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/1a95343c/attachment.html