Need to delete multiple lines in a file.

kangdom · #1 (**permalink**) 10-12-2006

Hi,

I'm new to this forum, and searched through the previous posts, but didn't see anything close enough to what i'm looking for.

I have a radius file like this:

Code:

testone          Password = "11111"
                    Service-Type = "Framed-User",
                    Session-Timeout = "9000",
                    Ascend-Idle-Limit = "900"
testtwo          Password = "11111"
                    Service-Type = "Framed-User",
                    Session-Timeout = "9000",
                    Ascend-Idle-Limit = "900"
testthree        Password = "11111"
                    Framed-Address = "000.000.000.000",
                    Framed-Netmask = "255.255.255.0"
                    Ascend-Route-IP=Route-IP-Yes
                    Framed-Route = "000.000.000.000/29 000.000.000.000 1 n"
1testone        Password = "11111"
                    Service-Type = "Framed-User",
                    Ascend-Idle-Limit = "900"
testtwo5        Password = "11111"
                    Service-Type = "Framed-User",
                    Session-Timeout = "9000",
                    Ascend-Idle-Limit = "900"
###EOF###

I need to search for an exact match of the username such as testtwo and delete that line and all the lines below it until I reach the next username.

The main problem is there is no set number of lines below the username, it could be anywhere from 2-8 lines.

The only constants are:

The username will allways be at the beginning of a new line and the word password will always and only be on the same line as the username.

I'm on a linux server, so any combination of sed, awk or perl should work.

Thanks in advance for any help.

vgersh99 · #2 (**permalink**) 10-12-2006

nawk -v name='1testone' -f kang.awk myFile.txt

kang.awk:

Code:

/^[^ ]/ { found= ($1 == name) ? 1 : 0 }
!found

ripat · #3 (**permalink**) 10-13-2006

Can not do better with sed (only worse).

Brilliant!

anbu23 · #4 (**permalink**) 10-13-2006

Code:

sed "/testtwo /,/Password/{/testtwo /d;/Password/!d;}" file

petebear · #5 (**permalink**) 10-14-2006

Quote:

Originally Posted by vgersh99

nawk -v name='1testone' -f kang.awk myFile.txt

kang.awk:

Code:

/^[^ ]/ { found= ($1 == name) ? 1 : 0 }
!found

Could someone explain this? I understand that "/^[^ ]/ " grabs all the usernames. and I think I understand the ternary operator; found equals true (1) if name (the username) is found in $1, or found equals false (0) if it's not. Then I get a bit lost, I think !found toggles the value of found, but why? And how does it all end up removing the username and all text between it and the next username. Thanks, pete.

petebear · #6 (**permalink**) 10-14-2006

Quote:

Originally Posted by vgersh99

nawk -v name='1testone' -f kang.awk myFile.txt

kang.awk:

Code:

/^[^ ]/ { found= ($1 == name) ? 1 : 0 }
!found

Could someone explain this? I understand that "/^[^ ]/ " grabs all the usernames. and I think I understand the ternary operator; found equals true (1) if name (the username) is found in $1, or found equals false (0) if it's not. Then I get a bit lost, I think !found toggles the value of found, but why? And how does it all end up removing the username and all text between it and the next username.

vgersh99 · #7 (**permalink**) 10-16-2006

Code:

# for lines NOT starting with a 'space'....
# set 'found' to '1' if if the first field is 'name' and to '0' otherwise
/^[^ ]/ { found= ($1 == name) ? 1 : 0 }

# if 'found == 0' - print the current line. could be rewritten as 'found == 0 {print $0}'
!found

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
regex to delete multiple blank lines in a file?	fedora	Shell Programming and Scripting	6	10-11-2007 04:36 PM
using sed command to delete a string spanning multiple lines	radha.kalivar	Shell Programming and Scripting	9	07-25-2007 10:26 AM
Delete multiple lines containting a variable string using SED.	selkirk	UNIX for Dummies Questions & Answers	2	04-27-2007 07:08 PM
delete multiple empty lines	whatisthis	Shell Programming and Scripting	3	11-09-2005 05:42 PM
Delete multiple lines w/ sed	bookoo	Shell Programming and Scripting	2	07-25-2003 10:03 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by