Question/help with concat lists into new field

HCL Domino Domino Forum
1

Hi everyone…

I have five fields, all are multi value…

selected1

selected2

selected3

currentList

newList.

the fields selected1 - selected3 all have different values listed.

I need to list all values from selected1 - selected3 and display the concatinated list in the newList field. I also need to check this new list with currentList and if dupe values are found in currentList, then do not include in newList.

This list needs to be the default value for newList field.

First, just to get a concat list, I’ve tried the following in the default value for newList, but the results are not correct…

@Unique(selected1)+@Unique(selected2)+@Unique(selected3)

or

@Unique(selected1):@Unique(selected2):@Unique(selected3)

Once I get the list correct in newList, I would try to use …

@Trim(@replace(newList, currentList, “”))

to compare the newList with currentList for removing dupes.

Any ideas? This is not working for me and I’m running out of ideas, it looks like it should be not too bad, but I can’t get it correct.

Thanks much !!

2

Subject: @Unique(selected1 : selected2 : selected3)

your code does not remove dupes from the new list; it builds a longer list from de-duplicated sublists, but the new, longer list may well have dupes from those three sublists. The @replace(@Trim()) doesn’t remove any dupes; it removes empty elements – and I don’t see where any of those would be introduced anyway. So you need no more than just

@Unique(selected1 : selected2 : selected3)

3

Subject: RE: @Unique(selected1 : selected2 : selected3)

Thank you for your help !!! That is what I needed

The whole code I’m doing is …

============

x:=@Unique(selected1 : selected2 : selected3);

@Trim(@Replace(x; usaCurrentAssigned; “”))

============

after using the line you gave, I check that list with the usaCurrentAssigned field to see if that field has any of the same values, (the dupes). Then, remove them in the list list.

Sorry, I should have given more info, it’s been a long Monday after a never ending Friday.

Again, thanks for the help !!!