This generates a query with all columns ordered alphabetically in the select statement. DECLARE @QUERY VARCHAR(2000) DECLARE @TABLENAME VARCHAR(50) = ‘<YOU_TABLE>’ SET @QUERY = ‘SELECT ‘ SELECT @QUERY = @QUERY + Column_name + ‘, ‘ FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @TABLENAME ORDER BY Column_name SET @QUERY = LEFT(@QUERY, LEN(@QUERY) – 4) + ‘ FROM ‘+ … Read more
Big Letter: chr(ord(‘@’)+number) 1 -> A 2 -> B … Small Letter: chr(ord(‘`’)+number) 1 -> a 2 -> b …
If you just want to view your class members in sorted order without modifying the code then you can click on the A/Z icon on the outline view, as others have pointed out. Alternatively, you may wish to sort the class members in the code itself, in which case you should right click your source … Read more
If you don’t want to add a dependency on Guava (per Michael’s answer) then this comparator is equivalent: private static Comparator<String> ALPHABETICAL_ORDER = new Comparator<String>() { public int compare(String str1, String str2) { int res = String.CASE_INSENSITIVE_ORDER.compare(str1, str2); if (res == 0) { res = str1.compareTo(str2); } return res; } }; Collections.sort(list, ALPHABETICAL_ORDER); And I … Read more
This is an iPhone feature, Android uses fast scroll. I’d recommend that you use the platform alternative rather than try to enforce common functionality. If you must, you’ll have to implement this yourself. Put your list view in a RelativeLayout and put A-Z TextViews in a vertical LinearLayout that is set to layout_alignParentRight=”true”. Set the … Read more
Programming 101: char c=”A”; //char c=”b”; you may use lower case character. int index = char.ToUpper(c) – 64;//index == 1
Pass a custom comparer into OrderBy. Enumerable.OrderBy will let you specify any comparer you like. This is one way to do that: void Main() { string[] things = new string[] { “paul”, “bob”, “lauren”, “007”, “90”, “101”}; foreach (var thing in things.OrderBy(x => x, new SemiNumericComparer())) { Console.WriteLine(thing); } } public class SemiNumericComparer: IComparer<string> { … Read more
Simple, direct solution function nextChar(c) { return String.fromCharCode(c.charCodeAt(0) + 1); } nextChar(‘a’); As others have noted, the drawback is it may not handle cases like the letter ‘z’ as expected. But it depends on what you want out of it. The solution above will return ‘{‘ for the character after ‘z’, and this is the … Read more
[] denotes a list, () denotes a tuple and {} denotes a dictionary. You should take a look at the official Python tutorial as these are the very basics of programming in Python. What you have is a list of strings. You can sort it like this: In [1]: lst = [‘Stem’, ‘constitute’, ‘Sedge’, ‘Eflux’, … Read more
Assuming that those are Strings, use the convenient static method sort: Collections.sort(listOfCountryNames)