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.7k views
in Others[杂七杂八] by (100 points)

how to extract following data like this example using bash shell script linux?

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. 

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

...