Manage Learn to apply best practices and optimize your operations.

Warning on trimming strings with @Trim and Trim

A warning about trimming functions in LotusScript and Formula.

I have been using LotusScript for years but have just found out that Trim(<string&>) in LotusScript is not the equivalent of @Trim in the formula language!

@Trim also removes redundant spaces within the string as well as leading and trailing white space, which the basic LotusScript Trim doesn't. While this normally might not make much of a difference, it does if you use both LotusScript and Formula language to build field values when the data changes in an external data source. The correct equivalent of @Trim is FullTrim in LotusScript with an example of its use below.

employeeName = firstname & " " & lastName
employeeName = FullTrim(EmployeeName)
doc.ED_FullName = employeeName
NB: You have to call Fulltrim after you have assembled your string, as it doesn't seem to like being wrapped around a formula (which you can do with Trim), as shown in the example above.

The issue came to light in a data conversion, as the data source for employee details was a relational database in which users were not shy about adding extra spaces wherever they felt like it, which really messed up my views -- especially those categorized by employee name.

Do you have comments on this tip? Let us know.

Dig Deeper on Lotus Notes Domino Formula Language

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...