Thank you for both of you I finally re-index data and remove 'C' and index
only numeric. So, that the way I fix my problem.
Best,
Chun.
--
View this message in context:
http://lucene.472066.n3.nabble.com/How-to-sort-value-that-numeric-mix-alpha-tp4144615p4144693.html
Sent from the Solr - Use
I think you wanted to remove letters, but your pattern removes NON-letters -
that's what the "^" does, negation.
So, try: ="[a-z]".
You can also get rid of the lower case filter and just use "[a-zA-Z]".
-- Jack Krupansky
-Original Message-
From: rachun
Sent: Sunday, June 29, 2014 3:
Try indexing your data as follows:
C01,C02,C03,C04,C09,C12,C23,C50
instead of
C1,C2,C3,C4,C9,C12,C23,C50
and the sort order would work correctly.
BTW, what you are describing as an issue is NOT unique to Solr. The same
happens on regular Databases as well. Google up how database type systems
