Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.8k views
in Technique[技术] by (100 points)

Extract multiple columns with no duplicate data with bash on linux

Hi all, i have a csv file like this: 

ecStudentID,StudentNetworkUsername,StudentName,StudentFirstName

100,ASTDTBJ001,"Andrew,Logan Connor",Logan

100,ASTDTBJ001,"Andrew,Logan Connor",Logan

101,BSTLTAN001,"Isaac,Matthew ",Matthew  

with bash how can I get column ID and first name without the duplicate. Example:

 ecStudentID,StudentFirstName

100,Logan

101,Matthew

Thank in advance 

Welcome To Ask or Share your Answers For Others

Please log in or register to answer this question.

Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...