I've got two regular text fields that I want to merge the contents of the two into another (third) text field, without any of the words repeating.

Field 1 - languages @ office 1

Field 2 - languages @ office 2

Field 3 - languages @ office 1&2

The two fields are more than likely going to contain different information in each. The languages are separated by a comma Ex - English, French, Russian, Jive, Polish, etc..

Both fields might contain the same language (or word) in each one. This is where I'm stumped. The words might be in different order, which make comparison difficult.

I'm attempting to perform a word count (X) on Field 1, loop X times based on that count, and in each loop compare word #x to Field 2. If Field 2 has that word, then skip it. Loop until last word. It hasn't given the results I expected.

Any ideas or suggestions on how to calculate/script this?

Thanks!

-Brent

May be some other stupid idea...

Set a text field called List.

Create a value list "ListSorted" using a SelfJoin on the unique Record_ID and targetting the 'List' field.

Then, run a script

SetField [List, Middle(Substitute(Field1,","),1,Position(Substitute(Field1,","),"@",1,1)-1) & "