<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><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>