Removing a space at the end of a field

HCL Domino Domino Forum
1

Hi there,

I’ve got approx 10,000 documents that I’m running an agent on based on a field value. In this field on some documents there is a space at the end which is causing my agents problems. Is there a way that I can replace this field value so that it doesn’t have the space at the end (i.e. "AAA " becomes “AAA”)?

Thanks!

2

Subject: Removing a space at the end of a field

Have you tried using @trim or the Trim function? They will remove any leading or trailing spaces.