bin/parse-contacts @ 9097174b115d

More
author Steve Losh <steve@stevelosh.com>
date Sun, 30 Aug 2020 17:26:18 -0400
parents 4237c4d29d58
children (none)
#!/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="	"