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

    Check print report PaymentAmountText field gets spaces while using RPAD Fn

    User395957

      Hi,

       

      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

      <?xdofx:rpad(PaymentAmountText,100,'*')?>

       

      But the output is as follows:

       

      Twenty-Five       Pounds    And      Fifty     Pence

      Only***********************************************

      **************

       

      There is a huge space between two words.

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