9 Replies Latest reply on Jun 6, 2016 9:45 PM by kiwikaty

    Finding on duplicates v13.9

    kiwikaty

      EDCURRIC 621/S1/E/LEC01/01+EDCURRIC 621/S1/E/LEC01/02+EDCURRIC 621/S1/E/LEC01/03+EDCURRIC 621/S1/E/LEC01/04 <6, 9-12>

       

      EDCURRIC 621/S1/E/LEC01/01+EDCURRIC 621/S1/E/LEC01/02+EDCURRIC 621/S1/E/LEC01/03+EDCURRIC 621/S1/E/LEC01/04 <5>

       

      Why does fmp client think these two values are the same and why do relationships fail when using strings like this?

       

      If I do a find on "!" these come back as a duplicate and I cannot do a "find" on the exact value as it says it has invalid find criteria which must be the "<" and ">" around the week values - I guess then when I am doing the find on "!" it is ignoring the characters at the end inside those?


      Sorry I think I have answered my own question while writing the post... the "<" and ">" in the data are the problem here and explain the funny join results I was getting also.

       

      Does anyone know of the url for fm that says what characters will cause these types of issues - Are they any of the ones used as find operators? (which would also explain why you cannot find on email addresses with the @ symbol).

       

      Many thanks

      KiwiKaty