1 Reply Latest reply on Apr 9, 2013 3:47 PM by philmodjunk

    Find text not shared between two fields

    caterinap

      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!

        • 1. Re: Find text not shared between two fields
          philmodjunk

               Storing multiple values in the same field suggest a less than optimum design for your table. Storing multiple values in two fields of same table? Even more so.

               It's easy to determine that Ref1 appears in both fieilds. It is not so easy to determine that Ref3 does not appear in Field2.

               A custom function could be devised in FileMaker Advanced that returns every value listed in Field3 that does not appear in Field2. That requires FileMaker Advanced to create and install in your file.

               A looping script could loop through the values in Field3 and return every value in listed in Field3 that does not appear in field2. This does not require FileMaker Advanced.