<div> Well that's why I put {#}\ \ <- to me, that says, put the numbers FIRST - then populate remaining length with spaces.</div>
<div> I understand that \0\ first, that would right justify, so my thought was put {#} first, THEN \ \ would left justify......</div>
<div> Anyway, I tried using the edit as you have it <br> lj [{!" "!}] {*}<br><br> But that didn't work either?? So I did the suggestion you gave in processing and that did the trick. Not sure why the edit didn't work though</div>
<div> </div>
<div> I labeled the edit a lj and for the edit - to spell it out - is left bracket,left curly bracket,exclamation point,double quote,space,double quote,</div>
<div> exclamation point,right curly bracket,right bracket,left curly bracket,asterisk,right curly bracket......that didn't seem to work though?</div>
<div> But not a huge deal....</div>
<div> </div>
<div> One other thing I need to know that I don't see - is there an edit to remove decimal from a number?</div>
<div> I have several (8,.2) fields that obviously show as 100.35, 16.34, etc.......However, for my file, I need to right justify, zero fill WITHOUT the</div>
<div> decimal. I have 0RJ working fine, but how do I remove the decimal??</div>
<div> </div>
<div> Thanks for all you help Ken</div>
<div> </div>
<div> Scott<br></div>
<div class="gmail_quote">On Thu, Aug 11, 2011 at 10:26 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:KandLBrody@gmail.com">KandLBrody@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">On 8/11/2011 10:18 AM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
[...]<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"> One more thing - how do you 'left justify, blank fill' a field?<br> I created a Global edit as such:<br>
<br> LJ = {#}\ \<-- hoping the space between the \ would create<br>blanks after the numbers<br></blockquote><br>Note that "\X\" is the syntax for right-justification, using the given character for filler rather than spaces. So, you are actually telling filePro to do the exact opposite of what you want -- your edit says "right-justify using spaces".<br>
<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"> I'm creating a file that is fixed length - but the field can be a variety<br>of numbers long -- but the fixed length is 17 characters<br>
So I need to left justify, blank fill this field.....<br><br> That edit didn't work.......anyone have syntax for a left justify field?<br></blockquote>[...]<br><br>Well, since you are probably doing this in processing anyway, why not just use processing to left-justify it?<br>
<br>Rather than:<br><br> xx(20,lj) = foo<br><br>Just use:<br><br> xx(20,*) = "" { foo<br><br>Of course, if you want an edit:<br><br> lj [{!" "!}] {*}<br><br>-- <br><font color="#888888">Kenneth Brody<br>
</font></blockquote></div><br>