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.