<div dir="ltr"><div>Doesn't work with or without the ",g" flag</div><div>If no ",g" flag, aa is always blank</div><div>If ",g" flag added, then aa is always equal to ab (so it shows the lowest and highest numbers are the same, which obviously isn't right)</div>
<div>Why is 'aa' always blank?</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 2:33 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>On 7/14/2014 1:57 PM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Ken,<br>
<br>
Here is what my output processing looks, with sort on client number (4<br>
characters and subtotal) and then full account number<br>
Everything works great except the 'starting (lowest)' number - 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>
</blockquote>
<br></div>
aa(4,#,g)=mid(3,"6","4") ; end<div><br>
<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
@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>
</blockquote></div>
[...]<div><br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
Any idea why 'aa' starting number is coming back blank?<br>
</blockquote></div>
[...]<br>
<br>
No ",g" flag.<span class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>