bin/parse-contacts @ f6bdfbdf747e

More
author Steve Losh <steve@stevelosh.com>
date Wed, 27 Mar 2024 15:17:47 -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="	"