sed help

So for a forum spam filter I need to extract the spam bot IP addresses from http://www.clanorb.com/banlist.php, and converts it into a single file with an IP address for each line.

I got stuck at this sed command:

sed -n -e '/159.148.11.5,/,/div/p' banlist.php > banlist

Code (markup):

But there is still html code at the end of the line that needs to be removed, but I didn't succeed in finding the sed command for that. Also the sed command I tryed for replacing the commas with line breaks isn't working:

sed 's/,/\n/g' csv.file  > linefeed.file

Code (markup):

Any help?

 

Maybe you like to use '$' as it will tell sed that it is the end of what you are trying to find.

 

Not entirely sure what you are trying to do, but you can MacGyver it with something like this...

wget http://www.clanorb.com/banlist.php && grep ^"<tr>" banlist.php | grep 7pt | cut -f4 -d '>' | tr -d "</span" > IPs

Code (markup):