Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Right justy data in ILE?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Right justy data in ILE?

    Check out opcode EVALR and built-in function %TRIMR.

  • #2
    Right justy data in ILE?

    Do you want blanks in the leftmost positions of the field? If so maybe you could do something like: evalr somefield = %trimr(somefield) If you want leading zeros, you could translate the blanks to zeros after the evalr.

    Comment


    • #3
      Right justy data in ILE?

      Is there a way to right justify data in a field? My alternative would be pull file up in Excel and change it there piece by piece since it supports only 65K records. But was curious if it can be done in the programming in an easier manner. What I have is data like 'bbbbbb12376512735bbbbb' or '32764bbbbbbbbbbbb' The letter b repesents a blank space. I am doing a conversion and this is coming from a very lovely free texted system. Gota love it. . . . .ok maybe not Thanks

      Comment


      • #4
        Right justy data in ILE?

        Thanks alot, that helped. Can't believe I over looked the evalr. Although when you stare at code all day I guess we all tend to forget and miss things. Thanks alot

        Comment

        Working...
        X