Search Results

Thank you very much Franklin52. It works well.

This perl script worked very well.

Thank you for all the script help.
Vimala

Hi,

I need to convert the following file into DB insert statements.



$ cat input.txt
START
name=john
id=123
date=12/1/09
END

START
name=sam
id=4234
status=resigned
date=12/1/08 ...

The output I get is
===
This is a file containing employee info
START
name john
id 123
date 12/1/09
END
Total records 2
Date of extraction: 12-3-09
===

Whereas the expected output is...

This worked. Thank you.

# awk 'BEGIN{RS=""}!/resigned/' file
However, it is missing the blank lines. Is there anyway to get the blank lines as well.

thanks,
Vimala

Thank you for your help.

awk '$0 !~ /START/{print}
$0 ~ /START/
{while ($0 !~ /END/){s=s"\n"$0;getline}s=s"\nEND";
if(s ~ /resigned/){s="";next}else {print s;s=""}}' filename


It...

Hi All,


The file has the following.

=========start of file===
This is a file containing employee info

START
name john
id 123
date 12/1/09
END

START
name sam
id 4234
date ...