AnsweredAssumed Answered

Force text length in calculation

Question asked by ChrisJohnston on Jan 23, 2014
Latest reply on Jan 23, 2014 by ChrisJohnston


Force text length in calculation


     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.