AnsweredAssumed Answered

Sorting not working correctly

Question asked by Mystick on Sep 7, 2010
Latest reply on Sep 7, 2010 by 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

Outcomes