UNIX for Dummies Questions & Answers

Hai

Please let me know the command in unix(command mode ) from a file that deletes the whole column (not 1st and last column )& replace with numbers starting from 1.

Regards
suneetha.

You need to post a snippet of the sample input file, as well as a sample of expected output. We also need to know how your fields are delimited.

Cheers
ZB

Hai

This is the format from which i want to delete the 2nd column and i have to replace it with numbers starting from 1. this file contains 1000 lines of the below format.

ATOM 131 N ASN I 19 13.270 -37.510 4.242 1.00 57.52
ATOM 132 CA ASN I 19 11.912 -37.066 4.598 1.00 57.72

plz let me know the command in unix in command mode.

Regards
suneetha.

Do not create multiple threads for the same topic. I have merged the threads.

Lets assume that your input filename is infile.txt
Here is the code that might solve your problem

cat -n infile.txt | cut -f1 | tr -d " " > tempfile2
cut -d" " -f1 infile.txt > tempfile1
cut -d" " -f3- infile.txt > tempfile3

paste -d" " tempfile1 tempfile2 tempfile3 > outfile.txt


Since we are not actually reading each, this program will run really very fast .

Does this serve the purpose?

Code:

awk ' { $2=NR; print }' file

Hey m not trying 2 cross ne1....

m jus askin 4 knowledge....wont this hav performance issue as compared to cut?

Which one is betr...i had a similar thing done for 150k records, so wud prefer using the best!