Notes Developer Question: Remove Spaces from a field

[Sweetworks]

I am trying to create an Agent in my CRM in Lotus Notes, and I am not finding any answers on my Google searches.


It is a simple thing that I can conceptualize in Excel, but can't figure out in Notes.
I just want to remove any spaces in a particular field
In excel you would just do a find/replace and have " " be replaced by "", and it should be something that can be done programmatically.

In the past I created a simple agent to replace the field
such as this
-------------
FIELD Category := "NY";
SELECT @All
-------------

I limited the view to just show the records I wanted to update, selected all;, then ran the agent.


The problem I have is the field, looks like these

Printing|409000|US|NY |
Printing|409010|US|CA |
Industrial|305040|US|NY|

I just want it to go though and remove the space

 

[nonguru]

in an agent you would use

@ReplaceSubString(FieldName; " "; "")


If it's an editable field, you could put this formula in the "Input Translation" event of the field so that it will remove spaces automatically for new documents.