Find and Remove rows

*******************************************
* ROW *
*******************************************
CODE:CODE1
FILE: FILE1
FIELD: FIELD1
KEY: KEY1
ORA-00001: unique constraint (ETL.KEY_PK) violated
*******************************************
* ROW *
*******************************************
CODE:CODE2
FILE: FILE2
FIELD: FIELD2
KEY: KEY2
ORA-00001: unique constraint (ETL.KEY_PK) violated

All I need is those 4 rows code,file,filed,key , what it the best way to delete the remaining like ******, *ROW ,
Objective , once I have only those fields, I have use excel and transpose to Columns from rows.
Thanks In Advance,

• S

$ cat sample13.txt
*******************************************
* ROW *
*******************************************
CODE:CODE1
FILE: FILE1
FIELD: FIELD1
KEY: KEY1
ORA-00001: unique constraint (ETL.KEY_PK) violated
*******************************************
* ROW *
*******************************************
CODE:CODE2
FILE: FILE2
FIELD: FIELD2
KEY: KEY2
ORA-00001: unique constraint (ETL.KEY_PK) violated

$ cat sample13.txt | grep -v "^*" | grep -v "^ORA"
CODE:CODE1
FILE: FILE1
FIELD: FIELD1
KEY: KEY1
CODE:CODE2
FILE: FILE2
FIELD: FIELD2
KEY: KEY2

Through awk..

awk '!/^(\*|ORA)/' inputfile

$ awk '!/\*/ && !/ORA/' input.txt
CODE:CODE1
FILE: FILE1
FIELD: FIELD1
KEY: KEY1
CODE:CODE2
FILE: FILE2
FIELD: FIELD2
KEY: KEY2

In sed..

$ sed -e '/\*/d' -e '/^ORA/d' infile

Thanks everyone for your help,

• S

with sed..

 sed '/\*\|ORA/d' filename

 
# egrep -v "^\*|^ORA"   my-file