i have a CSV file like below,
col1 col2 col3 col4 col5 col6 col7
a1 a2 a3 a4 a5 a6 a7
b1 b2 b3 b4 b5 b6 b7
c1 c2 c3 c4 c5 c6 c7
d1 d2 d3 d4 d5 d6 d7
Col1,col2.. are the column names and a1,a2,b1,b2.. are the data of the file.
i need to write a shell script, for here i need a check like which ever the unnecessary columns from the CSVfile have to be deleted, and mandatory columns sholud be specified in the scripts itself.
can any body help me on this for writing the shell script.
thanks in advance.