Sorting database text output
Sometimes it is nice to be able to quickly take column-formatted text output from the SQL command line and turn it into a list of useful data. In this case we want a unique, sorted list of the values from the second column combined into one comma-separated list. What is the fewest strokes you can do this in?
Start file
0 | 1 0 | 24 1 | 1 1 | 2 1 | 3 1 | 4 1 | 15 1 | 24 1 | 62 1 | 107 2 | 1 2 | 2 2 | 8 2 | 15 2 | 18 2 | 25 2 | 28 2 | 47 2 | 65 2 | 69 2 | 76 2 | 99 2 | 103 2 | 110 2 | 153 3 | 3 3 | 32 3 | 49 3 | 65 3 | 76 3 | 96 4 | 2
End file
1, 2, 3, 4, 8, 15, 18, 24, 25, 28, 32, 47, 49, 62, 65, 69, 76, 96, 99, 103, 107, 110, 153
View Diff
1,32c1 < 0 | 1 < 0 | 24 < 1 | 1 < 1 | 2 < 1 | 3 < 1 | 4 < 1 | 15 < 1 | 24 < 1 | 62 < 1 | 107 < 2 | 1 < 2 | 2 < 2 | 8 < 2 | 15 < 2 | 18 < 2 | 25 < 2 | 28 < 2 | 47 < 2 | 65 < 2 | 69 < 2 | 76 < 2 | 99 < 2 | 103 < 2 | 110 < 2 | 153 < 3 | 3 < 3 | 32 < 3 | 49 < 3 | 65 < 3 | 76 < 3 | 96 < 4 | 2 --- > 1, 2, 3, 4, 8, 15, 18, 24, 25, 28, 32, 47, 49, 62, 65, 69, 76, 96, 99, 103, 107, 110, 153
Solutions by @YannMoisan:
Unlock 6 remaining solutions by signing in and submitting your own entry