Left-justify (was Re: Export fixed length)

[Kenneth Brody]

On 8/11/2011 11:29 AM, scooter6 at gmail.com wrote:
>     ach(5) is the 5th field of the fixed length file I'm trying to create
>     ach(6) is the 6th field of the fixed length file I'm trying to create

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.

> Then: export ascii ach=/appl/fpmerge/achtest.txt r=\n -X
> Then: ach(1)="6";ach(2)="27";ach(3)=mid(1,"1","8");ach(4)=mid(1,"9","1")
> Then: aa(17,lj)=2;ach(5)=aa;
> Then: ab(10,0rjdot)=18;ach(6)=ab
> Then: write
> Then: end
[...]
>>>    Then: aa(17,lj)=2;ach(5)=aa<-- where field 2 is where I want to apply
>>> the edit
>>>
>>>    This did not left justify the field
[...]
>>    As well, doing the 0rjdot edit didn't change the field to zero-filled
>>> right justify amount
>>>
>>>    If:
>>>    Then: ab(10,0rjdot)=18;ach(6)=ab

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.

Add "f=|" to the export, and post a sample of what gets written to the 
export file.

-- 
Kenneth Brody