summary sheets from temp file

Bruce Easton bruce at stn.com
Mon Jul 14 12:04:29 PDT 2014


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 


More information about the Filepro-list mailing list