name;address;phone;email
John;123 La Sierra;555-121212;john@doe.com
Nick;456 La Bongaa;555-121232;nick@doe.com
Carl;789 La Fountain;553-121212;carl@doe.com

awk -F';' ' {print $2} ' myfile.csv

awk -F';' -v OFS=';' '{ $NF=""; print }' myfile.csv