This discussion is archived
3 Replies Latest reply: Sep 16, 2013 8:43 AM by AlexAnd RSS

Check print report PaymentAmountText field gets spaces while using RPAD Fn

user395957 Newbie
Currently Being Moderated



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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points