1 files changed, 37 insertions, 0 deletions
diff --git a/potpourri/ripe-prefixes-to-csv.awk b/potpourri/ripe-prefixes-to-csv.awk
new file mode 100644
index 00000000..37327484
--- /dev/null
+++ b/potpourri/ripe-prefixes-to-csv.awk
@@ -0,0 +1,37 @@
+#!/usr/bin/awk -f
+# $Id$
+
+# ftp -pa ftp://ftp.ripe.net/pub/stats/ripencc/membership/alloclist.txt
+
+function done() {
+    for (i = 1; i <= n_allocs; i++)
+	print handle "\t" alloc[i];
+    n_allocs = 0;
+}
+
+/^[a-z]/ {
+    done();
+    handle = $0;
+    nr = NR;
+}
+
+NR == nr + 1 {
+    name = $0;
+}
+
+NR > nr + 2 && NF > 1 && $2 !~ /:/ {
+    split($2, a, "/");
+    len = a[2];
+    split(a[1], a, /[.]/);
+    for (i = length(a); i < 4; i++)
+	a[i+1]  = 0;
+    alloc[++n_allocs] = sprintf("%d.%d.%d.%d/%d", a[1], a[2], a[3], a[4], len);
+}
+
+NR > nr + 2 && NF > 1 && $2 ~ /:/ {
+    alloc[++n_allocs] = $2;
+}
+
+END {
+    done();
+}