@FORMULA and list processing

HCL Domino Domino Forum
1

What is the best way to achieve the following using @FORMULA:

I have a Multivalue Field with the following values:

[1] A,

[2] ds,

[1] whw,

[2] hsdd,

[1] hj

I need to have 2 computed fields that will have the following when the document is saved:

1st Computed : A,whw,hg

2nd Computed : ds,hsdd

Thank you for your time.

2

Subject: @FORMULA and list processing

Something like this should work:

1st field:

@Right(MultiValueField;"[1] ")

2nd field:

@Right(MultiValueField;"[2] ")

3

Subject: RE: @FORMULA and list processing

And you can use @Trim to get rid of empty values. One thing to consider though is that you might have a value like “[2] test [1] test” then you may get the wrong results