Write a bash script named buildList that generates lists by selecting the specif

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 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 comma-separated 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 Cuser]$ cat cs229.csv Last,First,userid Huang,Xiaoqiu,xqhuang Jia,Yan Bin,jia Lathrop, Jim,jil Miner,Andrew,asminer Reiners,Dirk,dreiners Sheaffer, Jeremy, sheaffer Stolee,Derreck,dstolee Cuser]$ BuildList 3 cs252.csv ./././cs229.csv cs252: rassilon, bbritt, deanlin, asminer

Explanation / Answer

This is the script which will extract the specified columns apart from header

#!/bin/bash
a=$#
col=$1
args=("$@")
i=1
while [ $i -lt $a ]
do

   printf $(basename ${args[$i]} .csv)": "
   cut -d , -f $col ${args[$i]} | sed "1 d" | xargs | sed -e 's/ /,/g'
   let "i =i+1"
done

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.