something about awk or sed ?

yimaizhe · 09-19-2011, 02:01 AM

I have a big txt file,nearly 1Gb,and it contains 1000 rows and 1000 lines

now i want to delete 8th row(suppose),how should i do it ?
thanks

theYinYeti · 09-19-2011, 02:27 AM

What is the difference between a row and a line?
To delete the 8th line/row, you run “sed -ibak 8d /path/to/your/file”; your file will be modified, and you’ll have a backup file with the “bak” extension.
To delete the 8th column, you’ll have to play with awk instead, by correctly specifying the field separator, and outputing each line minus the 8th column.

Yves.

syg00 · 09-19-2011, 02:59 AM

Welcome back Yves - seems to have been a while since we've had the benefit of your knowledge.

yimaizhe · 09-19-2011, 03:48 AM

Quote:

Originally Posted by theYinYeti

What is the difference between a row and a line?
To delete the 8th line/row, you run “sed -ibak 8d /path/to/your/file”; your file will be modified, and you’ll have a backup file with the “bak” extension.
To delete the 8th column, you’ll have to play with awk instead, by correctly specifying the field separator, and outputing each line minus the 8th column.

Yves.

thanks a lot ,it works well ,and i am sorry for my unclear explaination