sed command or edit output

[Cliff Lewis]

I am trying to use the sed command to remove some lines in a text file. The
lines are like the following
(1 row affected)
(68 rows affected)
The number of rows could change, so is there a wildcard option.
Some lines have the following
-----------
----------------
the length varies.

What command would you use?
sed -e 's/? row affected)//' \
-e 's/?? rows affected)//' \
-e 's/??? rows affected)//' \
infile > outfile

This would work, but if at a later date the rows are > 10000 I will have to
fix. Trying not to do this.

Thanks in advance

[Cliff Lewis]

Answer my own question

Use the following command

sed -e /affected/D -e /----/D infile > outfile

[Julio Garcia_4]

Prove the next instruction:

grep -v "row affected" file | grep -v "rows affected"
> file_new