2 Replies Latest reply on Sep 7, 2010 10:46 AM by Mystick

    Sorting not working correctly

    Mystick

      Title

      Sorting not working correctly

      Post

      Hi,

      I have a text field on a list model. I sorted my model based on this field; Ascending.
      But it doesn't sort correctly. If I export my data in excel and sort on the field, it works.

      What could I do to have the same sorting as excel ? 

      Example of Filemaker result :

      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE770-140
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION CLASSIQUE
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE7814-140

      should have been  :

      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION CLASSIQUE
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE770-140
      serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)COLLECTION MODERNE7814-140

      thanks

      // Filemaker pro 10, windows xp

        • 1. Re: Sorting not working correctly
          philmodjunk

          You have a pretty long string that appears exactly the same in each of your examples: serveurdhcpANNUAIREITEMSACCESSOIRES ACAPOIGNÉESPOIGNÉES STANDARD ACA (COLLECTION MODERNE & CLASSIQUE)

          Is it always the same for all records you are sorting?

          If so, try setting up a caculation field that just extracts the last portion of this field, ( Collection Classique in the first example records after sorting ) and just sort on this one field.

          • 2. Re: Sorting not working correctly
            Mystick

            Hi,

            thanks a lot for your post, it made me understand the problem.

            my field doesn't always have the same beginning since this is a physical path to pdf files.

            But filemaker didn't sort it correctly because it only sort the first 100 characters of a string.

            I will use another field that i have and i will acheive my goal :)

            thaniks a lot !!!