AnsweredAssumed Answered

Finding on duplicates v13.9

Question asked by kiwikaty on Jun 6, 2016
Latest reply on Jun 6, 2016 by 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

Outcomes