awkseded

Delete third-to-last line of file using sed or awk


I have several text files with different row numbers and I have to delete in all of them the third-to-last line . Here is a sample file:

bear
horse
window
potato
berry
cup

Expected result for this file:

bear
horse
window
berry
cup

Can we delete the third-to-last line of a file:
a. not based on any string/pattern.
b. based only on a condition that it has to be the third-to-last line

I have problem on how to index my files beginning from the last line. I have tried this from another SO question for the second-to-last line:

> sed -i 'N;$!P;D' output1.txt

Solution

  • With tac + awk solution, could you please try following. Just set line variable of awk to line(from bottom) whichever you want to skip.

    tac Input_file | awk -v line="3" 'line==FNR{next} 1' | tac
    

    Explanation: Using tac will read the Input_file reverse(from bottom line to first line), passing its output to awk command and then checking condition if line is equal to line(which we want to skip) then don't print that line, 1 will print other lines.

    2nd solution: With awk + wc solution, kindly try following.

    awk -v lines="$(wc -l < Input_file)" -v skipLine="3" 'FNR!=(lines-skipLine+1)' Input_file
    

    Explanation: Starting awk program here and creating a variable lines which has total number of lines present in Input_file in it. variable skipLine has that line number which we want to skip from bottom of Input_file. Then in main program checking condition if current line is NOT equal to lines-skipLine+1 then printing the lines.

    3rd solution: Adding solution as per Ed sir's comment here.

    awk -v line=3 '{a[NR]=$0} END{for (i=1;i<=NR;i++) if (i != (NR-line)) print a[i]}' Input_file
    

    Explanation: Adding detailed explanation for 3rd solution.

    awk -v line=3 '             ##Starting awk program from here, setting awk variable line to 3(line which OP wants to skip from bottom)
    {
      a[NR]=$0                  ##Creating array a with index of NR and value is current line.
    }
    END{                        ##Starting END block of this program from here.
      for(i=1;i<=NR;i++){       ##Starting for loop till value of NR here.
        if(i != (NR-line)){     ##Checking condition if i is NOT equal to NR-line then do following.
          print a[i]            ##Printing a with index i here.
        }
      }
    }
    ' Input_file                ##Mentioning Input_file name here.