Fetches IANA Private Enterprise Numbers and prints a CSV (id,organization,contact,email) to stdout, converting obfuscated & emails to @.

iana_pen_to_csv.sh

#!/usr/bin/env bash
curl -fsSL 'https://www.iana.org/assignments/enterprise-numbers.txt' | awk '
BEGIN {
  OFS=","; print "id,organization,contact,email"
}
function trim(s){ sub(/^[ \t\r\n]+/, "", s); sub(/[ \t\r\n]+$/, "", s); return s }
function csvq(s){ gsub(/"/, "\"\"", s); return "\"" s "\"" }
# New record: a line with only digits
/^[0-9]+[ \t]*$/ {
  if (id != "") print csvq(id), csvq(org), csvq(contact), csvq(email)
  id=trim($0); org=""; contact=""; email=""
  next
}
# Organization: 2 leading spaces
/^  [^ ]/ { org=trim($0); next }
# Contact: 4 leading spaces
/^    [^ ]/ { contact=trim($0); next }
# Email: 6 leading spaces (IANA uses & for @)
/^      / {
  e=trim($0); gsub(/&/, "@", e); email=e; next
}
END {
  if (id != "") print csvq(id), csvq(org), csvq(contact), csvq(email)
}
'