Remove all the rows below a specific row number from one specific column
I've asked a question before on true row deletion, and got some great answers, but I'm now interested to know how you would remove all the rows below a specific row number from one specific column. All other columns and rows should remain intact.
As a bonus how would you also then paste/print another column into the specific deleted space
Example ( _columns are tab delimited_ ) - remove line 2 and all lines below it only in column 1, then shifting one column left move columns 2 and 3 from line 2 down:
# INPUT:
hunkey dorey pringle
jungley fevery jingles
freshly cutting jackle
Queen Kingly Squire
# OUTPUT:
hunkey dorey pringle
fevery jingles
cutting jackle
Kingly Squire
sed 'N,$s/^[^ ]\+[ ]\+//'
where N is the line number of the fist line to lose its first column.