2 Replies Latest reply on Jan 23, 2014 9:39 AM by ChrisJohnston

    Force text length in calculation

    ChrisJohnston

      Title

      Force text length in calculation

      Post

           Is there a way to take the use of the Left() or Right() function and return a number of characters if the second parameter is shorter only. It does not have to be with Left() or Right(); I use that as a starting place. So any other function or method to accomplish this.

      Example1: BOOKS::name =  The cat in the hat; Left(BOOKS::name; 15)
      Example2: BOOKS::name = Blue Bird; Left(BOOKS::name;15)  
      Both concatenated with a pipe would produce
      The cat in the |
      Blue Bird         |
      
      When using a monospaced font pipes would line up.