Jump to content

Merging contents of 2 text fields with no repeats


This topic is 7487 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. confused.gif

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

Thanks!

-Brent

Link to comment
Share on other sites

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) & "

Link to comment
Share on other sites

This topic is 7487 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.