Hello ,
When I am trying to sort by alphanumeric, it is not happening in proper manner.Please find below.Is it another way to sort alphanumeric?
match(n:t1) return n.qi,n.qd order by n.qi;
+----------------+
| n.qi | n.qd |
+----------------+
| "q1" | "q1" |
| "q10" | "q10" |
| "q11" | "q" |
| "q11b" | "q1" |
| "q12" | "q1" |
| "q13" | "q1" |
| "q1a" | "q1" |
| "q1b" | "q1" |
| "q2" | "q2" |
| "q3" | "q3" |
+----------------+
Out put should be like this:
+----------------+
| n.qi | n.qd |
+----------------+
| "q1" | "q1" |
| "q1a" | "q1" |
| "q1b" | "q1" |
| "q2" | "q2" |
| "q3" | "q3" |
| "q10" | "q10" |
| "q11" | "q" |
| "q11b" | "q1" |
| "q12" | "q1" |
| "q13" | "q1" |
+----------------+