posted 14 January 2012 15:45            

somelist.txt

Is there a simple solution (in Kyma or elsewhere on Mac, or PC) to sort a list of numbers written in a word processor document?

attached is demo list - as a illustration

how to order - sort them by "size"
(of course, 10,11, should be after 2 ...openoffice failed in that)

a son of my friend solved that in no time on linux, even explained (tried to) to me how it's done, in perfect geekish ...

any solutions for us mortals?

big thank you

posted 14 January 2012 16:20            

Import them into Excel and it will sort no problem.

posted 14 January 2012 16:44            

NumberSort.xls.zip

not quite so simple

after the import you will need to make a second column with formula

=VALUE(SUBSTITUTE(A1,"d hz","",1))

And then sort using that column

Pete

posted 15 January 2012 01:16            

1) open up Terminal (in Utilities)

2) type "sort -n" (without the speech marks)

3) drag somelist.txt onto the terminal window

so you should now have something like:

andrew$ sort -n /Users/USERNAME/Desktop/somelist.txt

4) continue to type " > /Users/USERNAME/Desktop/somesortedlist.txt" (again without the speech marks)

5) hit return

This passes your somelist.txt file to the sort command with the -n (numeric sort) option and redirects the output to a new file called somesortedlist.txt.

Edit USERNAME according to your own username so that the path to the files are right.

posted 15 January 2012 04:59            

NumberSorted.txt.zip

Thats what the formula is for.

It turns the text into a number and stops 10 and 1 coming next to each other.

Attached is the results from the spread sheet.

posted 15 January 2012 07:32            

o.k., I'll try the formula with openoffice when I install it on mac
so far it is only on my wife's linux machine

although it seems that I mastered the "terminal on osx" approach

thanx for helping me out people!

I knew that Kyma forum will find the solution

posted 15 January 2012 07:37            

quote:

---

Originally posted by SamuelSacher:
Hi Pete

o.k., I'll try the formula with openoffice when I install it on mac
so far it is only on my wife's linux machine

although, it seems that I mastered the "terminal on osx" approach

thanx for helping me out people!

I knew that Kyma forum will find the solution

ss

---