sed and multiline delete

aliyesami · 06-26-2008, 11:56 PM

there was an old thread with Pixellany posting a very nice solution for deleting one line above the pattern line as follows :
" sed '/^$/d' 2line |sed -n 'h;n;H;g;/Que/!p' "
Since the post is old iam not sure if he or someone else will look there so I am posting my question here also since i need this problem solved urgently hopefully sysadmin will forgive me for double posting

I want a line above and below the line starting with %CLI-E deleted including the pattern line itself if possible.

so for example I want these the following lines

$CHECKSUM $1$DGA243:[ORACLE.PATRON]FGAG01.DBF;1
%CLI-E-OPENIN, error opening $1$DGA243:[ORACLE.PATRON]FGAG01.DBF;1
-RMS-E-FLK, file currently locked by another user
$CHECKSUM $1$DGA1043:[ORACLE.PATRON]TSTST01.DBF;1
%CLI-E-OPENIN, error opening $1$DGA1043:[ORACLE]TSTST01.DBF
-RMS-E-FLK, file currently locked by another user
$CHECKSUM $1$DGA441:[ORACLE.PATRON]AFARG01.DBF;1
CHECKSUM 12142131

reduced to

%CLI-E-OPENIN, error opening $1$DGA1043:[ORACLE]TSTST01.DBF
%CLI-E-OPENIN, error opening $1$DGA243:[ORACLE.PATRON]FGAG01.DBF;1
$CHECKSUM $1$DGA441:[ORACLE.PATRON]AFARG01.DBF;1
CHECKSUM 12142131

or preferably this

$CHECKSUM $1$DGA441:[ORACLE.PATRON]AFARG01.DBF;1
CHECKSUM 12142131

thanks for your help
Sami
Florida

Mr. C. · 06-27-2008, 12:38 AM

Your results and data suggests that all you want are lines that start with "$CHECKSUM" and "CHECKSUM". Is this correct?

Sed is not the best tool for the job.

aliyesami · 06-27-2008, 08:43 AM

no its not correct ...I want everything else in file remain other than the two lines above and below the pattern line as I stated in the example.

Mr. C. · 06-27-2008, 02:03 PM

Code:

$ cat del.pl
#!/usr/bin/perl 

undef $/;
$_ = <>;

s/^.*?\n^%CLI-E.*?\n^.*?\n//gms ;

print "$_";