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
Get step-by-step solutions from verified subject matter experts
