bin/parse-contacts @ 8b5b2b90ac77

#!/usr/bin/env bash

# Parse a contacts.csv exported from Google (in Outlook format) into something
# human-usable.

set -euo pipefail

awk '{ $14 = $1 " " $2 " " $3; print $14, $15 }' FS=, OFS=, \
    | tail +2 - \
    | sed -Ee 's/ +,/,/' \
    | tr -s ' ' \
    | sort -t, -k2,1 -r \
    | awk '!seen[$2]++' FS=, OFS=, \
    | sort -t, -k2,2 \
    | awk '{ print $2, $1 }' FS=, OFS="	"