Blog TIL Now Tags Projects About
Terminal window
# getting Google search queries
xsv search -s URL 'google.+?q=' export.csv | rg 'q=(.+?)&' -o -r '$1' | tr '+' ' ' | sort | uniq
# getting unique URLs
xsv select URL export.csv | rg 'https?://(.+?)/' -or '$1' | sort | uniq

See also CSV SQLite Querying for an alternative approach.