AnsweredAssumed Answered

Find text not shared between two fields

Question asked by caterinap on Apr 9, 2013
Latest reply on Apr 9, 2013 by philmodjunk

Title

Find text not shared between two fields

Post

     Hello!

     Is there a way to find out the words (or character strings) that are in one field and not in another?

     For example :

     Field2               Field3

     Ref1;Ref2          Ref1;Ref3

     I would like to compare Field2 and Field3 and get "Ref3" as a result.

     Thank you in advance!

Outcomes