Text list operation : Sutraction

Hi there,

I have a basic question, I am looking for a way to do the reverse function of the @Keywords function, to extract all items that are in a list but not in the other.

I.E.:

List1 := “blue”:“red”:“green”:“yellow”

List2 := “blue”:“green”

MyNewList must be : “Red”:“Yellow”

The item in list1 that is NOT in list2.

Thx alot!

Sebastien Gignac

sgignac@novatechglass.com

Subject: Text list operation : Sutraction

I answered myself, here is my solution for those who face the same problem :

@Trim( @Unique( @Replace( Liste1 ; Liste2 ; @Nothing )))

Subject: NotInList2 := @Trim(@Replace(List1; List2; “”));