3 Replies Latest reply: Sep 16, 2013 10:43 AM by AlexAnd RSS

    Check print report PaymentAmountText field gets spaces while using RPAD Fn




      In the check print report we are using the PaymentAmountText field to print the amount in text.


      After printing the remaining spaces should be filled with '*'


      I used the below command



      But the output is as follows:


      Twenty-Five       Pounds    And      Fifty     Pence




      There is a huge space between two words.

      So please suggest some ideas to remove the space between two words.