# convert shallalist.tar.gz into csv # http://www.shallalist.de/categories.html # Harisfazillah Jamel 30032019 # wget -c http://www.shallalist.de/Downloads/shallalist.tar.gz # https://www.squidblacklist.org/downloads/dg-malicious.acl (masukkan dalam BL/malware dan tukar nama fail ke domains

process-blacklist-csv.sh

#!/bin/bash
# convert shallalist.tar.gz into csv
# http://www.shallalist.de/categories.html
# Harisfazillah Jamel 30032019
# wget -c http://www.shallalist.de/Downloads/shallalist.tar.gz
# https://www.squidblacklist.org/downloads/dg-malicious.acl (masukkan dalam BL/malware dan tukar nama fail ke domains

echo "\"localhost\",locahost" > malware3.tmp
find BL/ -name 'domains' -print0 | 
    while IFS= read -r -d $'\0' line; do 
        blgroup=`echo $line | cut -f 2 -d /`
        awk -v var="$blgroup" '$1 { print "\""$1"\",\"" var "\""}' $line >> malware3.tmp
    done

# use ctrl V and M after copy paste to replace ^M

sed -e "s/
//" malware3.tmp > malware3.csv