Shell Programming and Scripting

Hi Everyone,

I need some help to accomplish the below. help is highly appriciated.
I have a 45 mb file with ldap entries. Each user entry is separated by a string # entry-id: 1 and so on. Some of the entries has a string xyz: true. I want to delete the section if the user section has xyz: true in it. Below is the sample

example file:

# entry-id: 100
cn: test@test1.com
abc: 111
xyz: true
def: 222
hij: 333

# entry-id: 101
cn: test@test1.com
abc: 222
def: 222
hij: 333

# entry-id: 103
cn: test@test1.com
abc: 222
xyz: true
def: 222
hij: 333

# entry-id: 104
cn: test@test1.com
abc: 222
def: 222
hij: 333

out put file
# entry-id: 101
cn: test@test1.com
abc: 222
def: 222
hij: 333

# entry-id: 104
cn: test@test1.com
abc: 222
def: 222
hij: 333


Thanks in advance
Samingla

Code:

awk -vRS="\n\n" '! /xyz/' ORS="\n\n"

Only needed to remove xyz: true, perhaps:

Code:

 awk -vRS="\n\n" '! /\nxyz: true/' ORS="\n\n"

Hi Yinyuemi,

Thanks for the quick update. The awk that you have provided is not working as expected. I want the whole section to be deleted if the section has xyz: true in it. It is adding new line character in the string which is not required.

Thanks in advance.
Samingla

---------- Post updated at 06:57 PM ---------- Previous update was at 06:52 PM ----------

Hi chubler xl,
I need to delete the whole section if the section has xyz: true. Below is a section in the file that I am refering to.
# entry-id: 100
cn: test@test1.com
abc: 111
xyz: true
def: 222
hij: 333

Thanks,
Samingla

I'm confused, that is what the code does, the output matches your output file with the exception of a couple of extra newlines on the end.

Code:

awk 'BEGIN{RS="\n\n";ORS="\n\n"}!/xyz/{print}'  inputfile

In case it's the cause of the problem (truthfully, I did not read up closely as I'm still mostly asleep ), using more than one character for RS is a gawk extension. Perhaps what you want to do is set RS to an empty string. From the standard:

awk

Regards,
Alister

---------- Post updated at 02:20 AM ---------- Previous update was at 01:59 AM ----------

The following works fine (tested with nawk):

Code:

awk '!/(^|\n)xyz: true/' RS='' ORS='\n\n' file

Regards,
Alister