<div dir="ltr"><div>Here is the 'structure' part of the file that's pertinent</div><div> </div><div>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</div>
<div>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</div><div>Field 3 = 9,allup is the two fields combined with a "-" in middle 'i.e. 2435-0001, 2435-0002, 3194-0143, etc</div>
<div> </div><div>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</div>
<div> </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <span dir="ltr"><<a href="mailto:bruce@stn.com" target="_blank">bruce@stn.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Scott - check the sort screen for this - did you sort on Account Number,<br>
but only for a length of four?<br>
<br>
Bruce<br>
<div><br>
On 7/14/14 2:55 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
> adding 'end' in @sbrk1 had no effect - aa is still equal to ab on all<br>
> pages<br>
><br>
><br>
> On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <<a href="mailto:bruce@stn.com">bruce@stn.com</a><br>
</div><div>> <mailto:<a href="mailto:bruce@stn.com">bruce@stn.com</a>>> wrote:<br>
><br>
> Ah yes, the lack of "end" for @sbrk1 is probably why your aa is being<br>
> set to your ab.<br>
><br>
> Bruce<br>
><br>
> On 7/14/14 2:33 PM, Kenneth Brody wrote:<br>
> > On 7/14/2014 1:57 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
</div><div>> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>> wrote:<br>
> >> Ken,<br>
> >><br>
> >> Here is what my output processing looks, with sort on client<br>
> number (4<br>
> >> characters and subtotal) and then full account number<br>
> >> Everything works great except the 'starting (lowest)' number -<br>
> that is<br>
> >> coming out blank<br>
> >><br>
> >> :1="":end::gP*P|VW_L&4foSDs:<br>
> >> @sbrk1::aa(4,#)=mid(3,"6","4") 'this is the lowest number:<br>
> > aa(4,#,g)=mid(3,"6","4") ; end<br>
> ><br>
> >> @wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:<br>
> >> ::lookup cli=client k=1 i=A -nx:<br>
> >> ::ac(30,uplow)=cli(2) ' this grabs the name of the client:<br>
> >> ::end:<br>
> > [...]<br>
> >> Any idea why 'aa' starting number is coming back blank?<br>
> > [...]<br>
> ><br>
> > No ",g" flag.<br>
> ><br>
><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
</div>> <mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
><br>
<div><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
</div>URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/c48dae8d/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/c48dae8d/attachment.html</a><br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>