Tagged Questions
1
vote
1answer
313 views
Lookup and return value based on sub-string match
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g.
Input
COL_a COL_b
name ...
6
votes
2answers
330 views
In utf-8 collation, why 11- is less then 1-?
I found that the sort result in ASCII:
Source file test:
1-
11-
1-a
11-a
Sort using ASCII:
$ LANG=en_US.ascii sort test
1-
1-a
11-
11-a
And using UTF-8:
$ LANG=en_US.utf8 sort test
1-
11-
...
4
votes
2answers
1k views
GNU sort by case-sensitive
The sort utility in Ubuntu 10.04 (Lucid) always sort by case-insensitive, just like if you specify --ignore-case to it.
The two sort just give the same result:
echo -e "c\nb\nB\na" | sort
echo -e ...
1
vote
2answers
2k views
Windows “save” dialog listing files in reverse alphabetical order by default
Imagine this: no matter which software, when I hit "SAVE", the file explorer dialog that appears is listing my files in reverse-alpha order. This happens by default on all folders and is just an ...
0
votes
2answers
692 views
Windows Task Manager process ordering
Is there any rhyme or reason to the default ordering of the Windows Task Manager processes tab under Windows XP? It seems totally random.
And when sorting by CPU or memory, why do they default to ...
2
votes
1answer
1k views
How do you sort bookmarks in Safari alphabetically?
I have a lot of bookmarks in Safari and I would like to sort them alphabetically. It's a pain to do it manually, and I don't seem to find a "Sort alphabetically" menu option.
Is this at all possible?
...
1
vote
4answers
1k views
Sorting files (images) and then renaming them automatically according to the sort
We want to sort image files in a directory and want them to renamed according to the order we gave.
Is there a tool that can do this?
(os: windows xp)