Left-justify (was Re: Export fixed length)
scooter6 at gmail.com
scooter6 at gmail.com
Thu Aug 11 12:10:36 PDT 2011
Here is the output of the test file:
6|27|26317790|3| 5990094586421| 456.00
So, it appears it's creating the proper number of characters per field, but
the edits themselves aren't doing as they should?
Strange......
To confirm, I looked at the edits again.....attaching a screen shot to show
you what they look like in the edit file
On Thu, Aug 11, 2011 at 2:19 PM, Kenneth Brody <kenbrody at spamcop.net> wrote:
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20110811/f0bb5587/attachment.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: new_edits.jpg
Type: image/jpeg
Size: 74857 bytes
Desc: not available
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20110811/f0bb5587/attachment.jpg
More information about the Filepro-list
mailing list