Sorting Rows of a file

ghostdog74 · 05-27-2009, 03:11 AM

Quote:

Originally Posted by PMP

And if you have perl
do this :-)

cat test.txt
1,5,7,8,3,6
10,34,67,1,2,0,5

command line
perl -e 'while(<>){chomp; my @sorted = sort { $a <=> $b } split(",", $_); print join (",", @sorted); print "\n"}' test.txt
1,3,5,6,7,8
0,1,2,5,10,34,67

Cheers

note there is "x" in front of the numbers. also, Perl options -n simulates the while <> loop, so it can be omitted.

iframe · 05-28-2009, 04:38 AM

In order to make this script more portable, I modified it as follows

Code:

infile=$1

for i in $(cat $infile)
do 
   echo $i | tr "," "\n" | sort -n | tr "\n" "," | sed "s/,$//"
   echo
done

save it as: sort_file
usage: sort_file < sort_me.csv > outfile.csv

Thanks to all for your time and interest.

Quote:

Originally Posted by Admiral Beotch

Code:

for i in $(cat /tmp/numbers.txt); 
do
  echo $i | tr "," "\n" | sort -n | tr "\n" "," | sed "s/,$//"
  echo
done

$ cat /tmp/numbers.txt
4,2,5,3,1,6
9,7,10,8,11
$ /tmp/testnumbers
1,2,3,4,5,6
7,8,9,10,11
$