bin/parse-contacts @ a47b90b61621
More
| author | Steve Losh <steve@stevelosh.com> | 
|---|---|
| date | Fri, 03 Jan 2020 20:29:24 -0500 | 
| 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=" "