bin/parse-contacts @ 62f9cb575c0f
More
| author | Steve Losh <steve@stevelosh.com> | 
|---|---|
| date | Sun, 21 Apr 2019 22:27: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=" "