Write a BASH SCRIPT, NOT PEARL OR AWK OR ANYTHING ELSE. Write a bash script name

Question

Write a BASH SCRIPT, NOT PEARL OR AWK OR ANYTHING ELSE.

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 colnumber, 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 easie). For example: [userlS cat cs252.csv Last,First,username Aronnax,Miles,rassilon Britt,Barry,bbritt Lin,Dean,deanlin Miner, Andrew,asminer [userls cat cs229.csv Last,First,userid

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.