UNIX for Dummies Questions & Answers

Hi,

I have a comma delimited file. I want to sort the fields alphabetically and again store them in a comma delimited file.

For example, My file looks like this.

abc,aaa,xyz,xxx,def
pqr,ggg,eee,iii,qqq
zyx,lmo,pqr,abc,fff

and I want my output to look like this, all fields sorted alphabetically.

aaa,abc,def,xxx,xyz
eee,ggg,iii,pqr,qqq
abc,fff,lmo,pqr,zyx

Thanks

one way:

Code:

while read record
do
     echo "$record" | tr -s ',' '\n' | sort | tr -s '\n' ',' 
done < inputfile > outputfile

Code:

perl -i~ -F, -lane'print join",",sort@F' infile

Hi, Thanks a lot..Its working