Left-justify (was Re: Export fixed length)

[scooter6 at gmail.com]

  FWIW - I created a dummy file and defined 2 fields as lj and one as 0rjdot
  The left justify works when adding a record, but the 0rjdot does not.
  I created an export out of this test file, and it holds the left justify
field just fine??
  Perhaps for some reason if assigned to a variable it doesn't handle it
properly.
  Keeping in mind, in the 'main' file I'm using, the actual 'real' field I'm
using is 15,#
  Perhaps it doesn't handle assigning this to a dummy field with that edit??
  Kind of stumped on this one.....

  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
  one in it.
  If I put 455, when leaving the field it changes it to  00000455
  If I put 455.25, it changes it to 00455.25

  So apparently it doesn't acknowledge the 'remove decimal' part of the
edit?

  Scott

On Thu, Aug 11, 2011 at 3:10 PM, scooter6 at gmail.com <scooter6 at gmail.com>wrote:

>    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/3d8e1057/attachment.html