TSV

cities.tsv

telephone	city
555-123-4567	Seattle
555-231-3891	Copenhagen
555-893-1048	Madison
555-732-7320	Corvallis

cut -f1 cities.tsv > output1
telephone
555-123-4567
555-231-3891
555-893-1048
555-732-7320

cut -f2 cities.tsv > output2
city
Seattle
Copenhagen
Madison
Corvallis

phonebook.tsv

telephone	name
555-123-4567	Wally
555-231-3891	Beaver
555-893-1048	Lumpy
555-732-7320	June

join --header phonebook.tsv cities.tsv > output3
telephone name city
555-123-4567 Wally Seattle
555-231-3891 Beaver Copenhagen
555-893-1048 Lumpy Madison
555-732-7320 June Corvallis

CSV

cities.csv

telephone,city
555-123-4567,Seattle
555-231-3891,Copenhagen
555-893-1048,Madison
555-732-7320,Corvallis

phonebook.csv

telephone,name
555-123-4567,Wally
555-231-3891,Beaver
555-893-1048,Lumpy
555-732-7320,June

join -t , --header phonebook.csv cities.csv > output1.csv
telephone,name,city
555-123-4567,Wally,Seattle
555-231-3891,Beaver,Copenhagen
555-893-1048,Lumpy,Madison
555-732-7320,June,Corvallis

phonebookA.csv

name,telephone
Wally,555-123-4567
Beaver,555-231-3891
Lumpy,555-893-1048
June,555-732-7320

join -t , -1 2 -2 1 --header phonebookA.csv cities.csv > output2.csv
telephone,name,city
555-123-4567,Wally,Seattle
555-231-3891,Beaver,Copenhagen
555-893-1048,Lumpy,Madison
555-732-7320,June,Corvallis


Includes | Jekyll

join invocation | GNU Coreutils 9.1