UNIX for Beginners Questions & Answers

Extremely sorry rudic, I forgot to copy

Code:

>

special character. it works fine.

Dear Singh,
I need to add one more feature in your command. I have excel file names as shown below

Code:

org1.xls org2.xls org3.xls org4.xls org5.xls ........... org30.xls

The columns 1 and 5 to be pasted into a new excel file as file existing order. But all the commands suggested here are not printing the columns as per the file existing order.
I need to print org1.xls columns 1, 5 followed by org2.xls, org3.xls ......org30.xls. Is it possible?

Try

Code:

 > RES; for FN in $(ls *.xls | sort -t. -k1.4n); do cut -f1,5 $FN | paste - RES > TMP; mv TMP RES; done

Its printing exactly reverse order. The last file (0rg30) columns printed first followed by org29, org28 ......org1.

Hello dineshkumarsrk,

Could you please try following(taking ls adoption from RudiC's solution).

Code:

ls *.xls | sort -t. -k1.4n |  awk '{a[FNR]=a[FNR]?a[FNR] OFS $1 OFS $4:$1 OFS $4} END{val=length(a); for(i=1;i<=val;i++){print a[i]}}'

Fair warning I haven't tested it.

Thanks,
R. Singh

Sorry singh,
It is only printing the files as given below,

Code:

org1.xls
org2.xls
org3.xls
.
.
.
org30.xls

Try the -r option to sort. And, e.g. man sort sometimes helps.