Problem with concatenation

HCL Domino Domino Forum
1

Hi all

I am having a computed field which concatenates a values from the various field(dialog list)

value:=text1+text2+text3+text4+text5

text 1,text2,text3,text4,text5 are dialog list values which contains more that a value

The field “value” is a multi value text field & it is seperated by comma.My problem is that if there is no value in text3 or text 2 there occurs an extra comma ,how to eliminate this

For e.g if text1 has a,b & text 2 has c value

The text in the value field appears as a,b,c,since there is no values for text4 & text5

Does anyone has any idea

Thanks in advance

Shobana

2

Subject: Problem with concatenation

@trim…

3

Subject: RE: Problem with concatenation

you wanna do a list concatenation and use a @trim, likebelow :

value := @trim(text1 : text2 : text3)