Agent to delete one of a multiple value field

HCL Domino Domino Forum
1

Problem - field MailAddress has 2 values1st value is “” or null

2nd value is "john.smith@work.com

I need to delete the “” or null value completely

but retain the 2nd value.

I have tried multiple formulas such as delete field, replace substring etc etc with the problem being that I always delete both values.

2

Subject: Agent to delete one of a multiple value field

Hi,

you can use @Trim in formula or Fulltrim in LotusScript

both will remove leading and trailing spaces and remove empty occurrences in lists.

Dave