Crystal Report 7.0 field formatting issue

[cjohnson6]

Can anyone assist me?<br>I have a report created but on certain fields I need to have the excess space within those fields to be suppressed. <br>How can this be accomplished?<br>I've tried to use the Section Expert and formatting the individual fields but can't seem to get the results I need. Should I be using formulas to do this and if so, what is the basic syntax for doing so?<br>Ex. - TrimStr(?)<br><br>Any direction anyone can provide would<br>be appreciated.<br><br>Thanks in advance,<br>Claude <br><br>

 

[Nilsen]

You can use the formula:<br><br>Trim(str) to clear all the spaces from a string.&nbsp;&nbsp;If you are trying to clear the spaces from the beginning or end of the string you can use TrimLeft(str) or TrimRight(str) or both if you wish to keep spaces in the middle.