@Replace in input translation not removing space

HCL Domino Domino Forum
1

I have an input translation formula thus:

@Trim(@Replace(fieldName;" “;”"))

and although it is triming the field values it is not replacing spaces with no spaces.

any ideas ?

thanks

2

Subject: @Replace in input translation not removing space

@Replace works on complete list entries – your @Replace is looking for entries that consist of only a single space and replacing them with empty strings. I think you’re looking for @ReplaceSubstring.

3

Subject: RE: @Replace in input translation not removing space

You know, you are right.

i apologise for being an idiot. I’ve spent too long playing with portals and been too long away from notes.

thanks Stan.