Shell Programming and Scripting

FileA
NAME STATE CITY
---- ---- -----
abc ca ca
bcc ny ny
def nj nj

(3 rows affected)

Q1) I want to delete the second row with is ---- ---- -----.
Can delete 2nd row using following

Code:

sed '2d' FileA >FileB

but incase the second record is not ---- ---- -----.
then data will get deleted how to implement this logic to check ---- ---- ----- before deleting.



Q2) the last row will be (x rows affected)
i can implement this using

Code:

sed '$d' FileA > FileB

but in case last record is not (x rows affected)
data gets deleted how can i handle this.
I want to check before deleting.


Appreciate help.

don't delete as SECOND and LAST. Delete as 'beginning "with ----" ' and 'containing "rows containing)" '.

try this

Code:

sed -e '/^--.*$/d' -e '/^(.*rows affected)$/d' fileA >fileB

cheers,
Devaraj Takhellambam

Thank you Devaraj Takhellambam and vgersh99