{"action":"created","issue":{"url":"https://api.github.com/repos/handsontable/handsontable/issues/2930","labels_url":"https://api.github.com/repos/handsontable/handsontable/issues/2930/labels{/name}","comments_url":"https://api.github.com/repos/handsontable/handsontable/issues/2930/comments","events_url":"https://api.github.com/repos/handsontable/handsontable/issues/2930/events","html_url":"https://github.com/handsontable/handsontable/issues/2930","id":113493087,"number":2930,"title":"Column Sorting problem","user":{"login":"douxlagithub","id":4103210,"avatar_url":"https://avatars.githubusercontent.com/u/4103210?v=3","gravatar_id":"","url":"https://api.github.com/users/douxlagithub","html_url":"https://github.com/douxlagithub","followers_url":"https://api.github.com/users/douxlagithub/followers","following_url":"https://api.github.com/users/douxlagithub/following{/other_user}","gists_url":"https://api.github.com/users/douxlagithub/gists{/gist_id}","starred_url":"https://api.github.com/users/douxlagithub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/douxlagithub/subscriptions","organizations_url":"https://api.github.com/users/douxlagithub/orgs","repos_url":"https://api.github.com/users/douxlagithub/repos","events_url":"https://api.github.com/users/douxlagithub/events{/privacy}","received_events_url":"https://api.github.com/users/douxlagithub/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/handsontable/handsontable/labels/Answered","name":"Answered","color":"006b75"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-27T02:36:33Z","updated_at":"2015-10-28T04:40:15Z","closed_at":"2015-10-28T04:40:15Z","body":"Hello handsontable experts, I just want to sort my column to follow what so called a \"Natural Sorting\". Like below: \r\n1\r\n1.1\r\n1.2\r\n1.3\r\n...\r\n1.10\r\n1.11\r\n1.2\r\n1.2.1\r\n1.2.2\r\n...\r\n1.2.10\r\n1.2.11\r\netc...\r\n\r\nCurrently sorting is not natural. I found it like the following \r\n1\r\n1.1\r\n1.10\r\n1.2\r\n\r\nWhere the 10 comes before 2. helps would be appreciated.....! :)"},"comment":{"url":"https://api.github.com/repos/handsontable/handsontable/issues/comments/151719282","html_url":"https://github.com/handsontable/handsontable/issues/2930#issuecomment-151719282","issue_url":"https://api.github.com/repos/handsontable/handsontable/issues/2930","id":151719282,"user":{"login":"douxlagithub","id":4103210,"avatar_url":"https://avatars.githubusercontent.com/u/4103210?v=3","gravatar_id":"","url":"https://api.github.com/users/douxlagithub","html_url":"https://github.com/douxlagithub","followers_url":"https://api.github.com/users/douxlagithub/followers","following_url":"https://api.github.com/users/douxlagithub/following{/other_user}","gists_url":"https://api.github.com/users/douxlagithub/gists{/gist_id}","starred_url":"https://api.github.com/users/douxlagithub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/douxlagithub/subscriptions","organizations_url":"https://api.github.com/users/douxlagithub/orgs","repos_url":"https://api.github.com/users/douxlagithub/repos","events_url":"https://api.github.com/users/douxlagithub/events{/privacy}","received_events_url":"https://api.github.com/users/douxlagithub/received_events","type":"User","site_admin":false},"created_at":"2015-10-28T04:40:15Z","updated_at":"2015-10-28T04:40:15Z","body":"Thank you very much for reply. Actually  I did it in MySQL by utilizing SUBSTRING_INDEX to manipulate the dotted number. But later I had to use SQLite which was not support SUBSTRING_INDEX. So I thought, the final solution was HOT sorting, but no way. thanks again....!"}}