Question: Write a bash script named buildList that generates lists by selecting the specified column of a spreadsheet stored in CSV format. The script should be

Write a bash script named buildList that generates lists by selecting the specified column of a spreadsheet

stored in CSV format. The script should be invoked as

BuildList ...

where column is the desired column number, and any remaining arguments are input files. The output

should be a single line for each input file, consisting of the filename with directory and extension .csv

removed, and a commaseparated list built from the specified column of the spreadsheet. The first line of

the spreadsheet is assumed to be column headers, and should be ignored. The script may invoke sed and

awk if needed (in fact this is encouraged, because it will make your solution easier). For example:

[user]$ cat cs252.csv

Last,First,username

Aronnax,Miles,rassilon

Britt,Barry,bbritt

Lin,Dean,deanlin

Miner,Andrew,asminer

[user]$ cat cs229.csv

Last,First,userid

2

Huang,Xiaoqiu,xqhuang

Jia,Yan Bin,jia

Lathrop,Jim,jil

Miner,Andrew,asminer

Reiners,Dirk,dreiners

Sheaffer,Jeremy,sheaffer

Stolee,Derreck,dstolee

[user]$ BuildList 3 cs252.csv ./././cs229.csv

cs252: rassilon, bbritt, deanlin, asminer

cs229: xqhuang, jia, jil, asminer, dreiners, sheaffer, dstolee

[user]$ BuildList 2 cs229.csv cs252.csv

cs229: Xiaoqiu, Yan Bin, Jim, Andrew, Dirk, Jeremy, Derreck

cs252: Miles, Barry, Dean, Andrew

[user]$

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!