I was looking for a function or a solution if it already exists but was not able to find one.

Basically I am looking for a way to compare two sets of data (text) and write out the differences.

I got as far as comparing text in two fields to check if it is same, that was easy. How would I make it so that if the text is different the different text gets showed in a new field by itself or if possible the whole text with the differences highlighted?

Something like:

Field1: This is a test.

Field2: This is a tes.

Result: This is a tes[color:red]t.

or

Result: t

The first way is preferable.

Thanks.,

See:

http://www.fmforums.com/forum/showtopic.php?tid/191120

http://fmforums.com/forum/showtopic.php?tid/193445/post/282259/

Heh, thanks for the links. Nice to know.

You might want to look at this plugin:

http://www.360works.com/difference/

Thanks.,