bin/parse-contacts @ 955d032c46cc
More cleanup
author | Steve Losh <steve@stevelosh.com> |
---|---|
date | Fri, 18 Mar 2022 15:20:26 -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=" "