AnsweredAssumed Answered

Force text length in calculation

Question asked by ChrisJohnston on Jan 23, 2014
Latest reply on Jan 23, 2014 by 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.

Outcomes