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:
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 -n -e '/18.104.22.168,/,/div/p' banlist.php > banlist
sed 's/,/\n/g' csv.file > linefeed.file