Eric Berry wrote a handy class that compares Strings by human values instead of traditional machine values. Below is a modified version of it along with Object comparator (what I think you are looking for) and its testing class. An example on how to use the string comparator: Map<String,String> humanSortedMap = new TreeMap<>(new AlphaNumericStringComparator()); An … Read more
Hope this helps. I’m not sure it’s the best way to approach your problem, but it should help you to familiarise yourself with some of the options / see why some of the guys on here are advising against it. If you let us know more about what you’re trying to do we can better … Read more
Lucky for you, I’ve done this once before. the problems I’ve encountered is that in the Excel sheet there is no 0, not even in double ‘digit’ ‘numbers’. meaning you start with a (that’s 1) and then from z (that’s 26) you go straight to aa (27). This is why is’t not a simple base … Read more