Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC:

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18803

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
I am trying to get a Total Amount in my footer variable for a fixed width file.

I am having a challenge trying to use the Running Total and have it Right Justified including leading zeroes which is data requirement. The field length is fixed at 11 num characters. I tried doing a Right Pad at 9 which didn't accomplish the justification and not sure how to lead the 0's once I get it justified.

Attached are screenshots of the transformations.

The Right Pad is set to 0 to pad to the length of 11 characters.

Attachments:

Please Log in or Create an account to join the conversation.

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18804

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7855
  • Karma: 33
  • Thank you received: 474
Please try putting right pad after the running total
Mike

Please Log in or Create an account to join the conversation.

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18805

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
I tried that option before but here is the result. It still puts the total starting at position 30. The requirement says Right Justify with leading Zeroes. I would need to get the total at the right side of the 11 character field length and include the 0's. Thank you this model is done minus this last requirement.
Attachments:

Please Log in or Create an account to join the conversation.

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18806

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0

File Attachment:

File Name: SELLMANTES...TEXT.txt
File Size:60 KB
Attachments:

Please Log in or Create an account to join the conversation.

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18807

Can you try using "left pad" instead of "right pad"

Attachments:

Please Log in or Create an account to join the conversation.

Right Justify with Leading Zeroes in a Fixed Width File with <footer> Variable 1 year 8 months ago #18808

  • cchavez
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 26
  • Thank you received: 0
The right pad was the ticket and thanks Maria. The last part is padding this section with 0's. I dropped in the Pad = 0 but it doesn't seem to fill in. TIA the padding is the last thing I need to do to test this upload:)
Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2

We have 159 guests and no members online