<div> FWIW - I created a dummy file and defined 2 fields as lj and one as 0rjdot</div>
<div> The left justify works when adding a record, but the 0rjdot does not.</div>
<div> I created an export out of this test file, and it holds the left justify field just fine??</div>
<div> Perhaps for some reason if assigned to a variable it doesn't handle it properly.</div>
<div> Keeping in mind, in the 'main' file I'm using, the actual 'real' field I'm using is 15,# </div>
<div> Perhaps it doesn't handle assigning this to a dummy field with that edit??</div>
<div> Kind of stumped on this one.....</div>
<div> </div>
<div> The 0rjdot doesn't work -- it allows me to enter any number, but it DOES zero fill and right justify, it just doesn't remove the decimal if I put</div>
<div> one in it.</div>
<div> If I put 455, when leaving the field it changes it to 00000455</div>
<div> If I put 455.25, it changes it to 00455.25</div>
<div> </div>
<div> So apparently it doesn't acknowledge the 'remove decimal' part of the edit?</div>
<div> </div>
<div> Scott<br><br></div>
<div class="gmail_quote">On Thu, Aug 11, 2011 at 3:10 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <span dir="ltr"><<a href="mailto:scooter6@gmail.com">scooter6@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">
<div> Here is the output of the test file:</div>
<div> </div>
<div> 6|27|26317790|3| 5990094586421| 456.00</div>
<div> </div>
<div>So, it appears it's creating the proper number of characters per field, but the edits themselves aren't doing as they should?</div>
<div>Strange......</div>
<div> </div>
<div>To confirm, I looked at the edits again.....attaching a screen shot to show you what they look like in the edit file</div>
<div>
<div></div>
<div class="h5">
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Thu, Aug 11, 2011 at 2:19 PM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>On 8/11/2011 11:29 AM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"> ach(5) is the 5th field of the fixed length file I'm trying to create<br> ach(6) is the 6th field of the fixed length file I'm trying to create<br>
</blockquote><br></div>Okay. Since you didn't say, it was possible that they were fields in a lookup file with an edit that would have "undone" whatever formatted you did to get it into aa and ab.<br><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div>Then: export ascii ach=/appl/fpmerge/achtest.txt r=\n -X<br></div>
<div>Then: ach(1)="6";ach(2)="27";ach(3)=<u></u>mid(1,"1","8");ach(4)=mid(1,"<u></u>9","1")<br></div>
<div>Then: aa(17,lj)=2;ach(5)=aa;<br></div>
<div>Then: ab(10,0rjdot)=18;ach(6)=ab<br></div>Then: write<br>Then: end<br></blockquote>[...]
<div><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"> Then: aa(17,lj)=2;ach(5)=aa<-- where field 2 is where I want to apply<br>the edit<br><br> This did not left justify the field<br>
</blockquote></blockquote></blockquote></div>[...]
<div><br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote"> As well, doing the 0rjdot edit didn't change the field to zero-filled<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">right justify amount<br><br> If:<br> Then: ab(10,0rjdot)=18;ach(6)=ab<br></blockquote></blockquote></blockquote>
<br></div>Given the above code, and the "lj" and "0rjdot" edits I provided, I don't see how ach(5) can be something other than left-justified within a 17-character field, and ach(6) be anything other than right-justified zero-padded decimal-removed within a 10-character field.<br>
<br>Add "f=|" to the export, and post a sample of what gets written to the export file.<br><br>-- <br><font color="#888888">Kenneth Brody<br></font></blockquote></div><br></div></div></blockquote></div><br>