Removing a specific line from a file

in-place with ed (on the bash prompt)

ed -s file <<<$'/Products below/d\nw'

Or as don crissti recommends:

ed -s file <<<$'/Products below/d\nw\nq'

perl oneliner:

perl -ne 'print unless (m/Products below/') FILE

If we can safely assume that you want to delete all lines that start with Products (including the space after the 1st word), these will all work:

• awk

  awk '$1!="Products" file > newfile
  

• perl

  perl -ne 'print unless /^Products/' file > newfile
  

  or

  perl -ane 'print if $F[0]!="Products"' file > newfile
  

  or, to edit the file in place

  perl -i -ne 'print unless /^Products/; ' file
  perl -i -ane 'print if $F[0]!="Products"' file 
  

• grep (this is just a shorter version of svq's answer)

   grep -v ^Products file > newfile
  

• bash (just for the fun of it)

  while read line; do [[ $line =~ ^Products ]] || echo $line; done <  file > newfile
  

With your input data, you can try:

$ sed '/^Products/d' file 
Number, month, year, reference, store
1,1,2014,13322,main
2,2,2014,13322,main
3,3,2011,1322,main
4,4,2012,3322,main
5,4,2013,122,secondary
12,411,2010,122,Albany
25,41,2009,122,Dallas
35,24,2008,122,New

Using sed -i.bak to edit the file inplace and create a backup file:

sed -i.bak '/^Products/d' file

You can use sed to search pattern to delete each line what contain this pattern

sed -i '/Products below this line are out of stockNumber, month, year, reference, store/d' file

Here is yet another example of using sed:

sed '/^Products below this line are out of stockNumber, month, year, reference, store$/d' originalDocument > newDocument