Input Translation and adding a value

HCL Domino Domino Forum
1

I have a field which is multi-value. I want to check to see if it contains the symbol @. If not I want to add it to all the values that don’t have it.

Here’s my input translation formula which works only on the first value and not the rest. How do I get it to check all the values?

@If(!@Contains(Config_DeptExceptions150;“@”);Config_DeptExceptions150 +“@Ahlstrom”;Config_DeptExceptions150)

2

Subject: Input Translation and adding a value

Stu,

The problem with a multi-value field is that you need to check each value independently. So you’ll want something like:

list := myField;

@Transform(list; “x”; @if(@Contains(x; “@”); x; x + “@Ahlstrom”);

list

I haven’t tested that line of code, but I think it’s accurate.

regards,

raphael

3

Subject: RE: Input Translation and adding a value

Thanks for the help.

Here’s the formula I used that worked:

@Transform(Config_DeptExceptions150; “x”;

@If(!@Contains(x; “@”);x + “@Ahlstrom”; x ))