Welcome to OGeek Q&A 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 reply this article.

OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...