ecStudentID,StudentNetworkUsername,StudentName,StudentFirstName
100,ASTDTBJ001,"Andrew,Logan Connor",Logan
100,ASTDTBJ001,"Andrew,Logan Connor",Logan
101,BSTLTAN001,"Isaac,Matthew ",Matthew
Hi all i have a csv file this one. And I want to use bash to extract certain information like first name and ID but it will have duplicate. How can I extract the certain column and no duplicate on it?
This is the output I want :
ecStudentID,StudentFirstName
100,Logan
101,Matthew
Thank in advance.