Help with column delete from multiple files

Shell Programming and Scripting
1

sample .csv files with 7 columns.I want to delete the last column from each of the below files but retain their file names (1_ContractDocuments.csv,2_ContractDocuments.csv etc.)
There can be more files like 3_ContractDocuments.csv , 4_ContractDocuments.csv . Can you please help

source .csv files :

file 1 : 1_ContractDocuments.csv

CW2218471,testfile2.pdf,CW2218471/WS1033214854/Doc1043743258.pdf,Final Contract Document(s),,Published,1
CRW2218451,testfile1.pdf,CW2218471/CRW2218451/Doc1031919943.pdf,Main,,Published,1
CRW2218451,testfile3.pdf,CW2218471/CRW2218451/Doc1031919945.pdf,Main,,Published,1
CRW2218451,testfile4.pdf,CW2218471/CRW2218451/WS1031919946/Doc1031919947.pdf,Main,,Published,1

file 2 : 2_ContractDocuments.csv

CW22,testfile2.pdf,CW22/WS1033214854/Doc1043743258.pdf,Final Contract Document(s),,Published,1
CRW22,testfile1.pdf,CW22/CRW2218451/Doc1031919943.pdf,Main,,Published,1
CRW22,testfile3.pdf,CW22/CRW2218451/Doc1031919945.pdf,Main,,Published,1
CRW22,testfile4.pdf,CW22/CRW2218451/WS1031919946/Doc1031919947.pdf,Main,,Published,1

output expected :

file 1 : 1_ContractDocuments.csv (name of file same as before with last column deleted)

CW2218471,testfile2.pdf,CW2218471/WS1033214854/Doc1043743258.pdf,Final Contract Document(s),,Published
CRW2218451,testfile1.pdf,CW2218471/CRW2218451/Doc1031919943.pdf,Main,,Published
CRW2218451,testfile3.pdf,CW2218471/CRW2218451/Doc1031919945.pdf,Main,,Published
CRW2218451,testfile4.pdf,CW2218471/CRW2218451/WS1031919946/Doc1031919947.pdf,Main,,Published

file 2 : 2_ContractDocuments.csv (name of file same as before with last column deleted)

CW22,testfile2.pdf,CW22/WS1033214854/Doc1043743258.pdf,Final Contract Document(s),,Published
CRW22,testfile1.pdf,CW22/CRW2218451/Doc1031919943.pdf,Main,,Published
CRW22,testfile3.pdf,CW22/CRW2218451/Doc1031919945.pdf,Main,,Published
CRW22,testfile4.pdf,CW22/CRW2218451/WS1031919946/Doc1031919947.pdf,Main,,Published
2

Any attempt / idea / thought from your side?

And, use code tags correctly: for code and data. DON'T enclose your entire post in code tags!

3

yes I tried this . But it did not work ..

for FILE in *_ContractDocuments.csv
do  grp=$( echo $FILE | awk -F '_' '{print $1}' )
    cut -d ',' -f 1,2,3,4,5,6 < $FILE > $grp_ContractDocuments.csv
done
4

you don't need a for loop.
Just an example to start with:

awk -F, 'NF--' OFS=, myFile.csv
5

I want to keep the same file names .How do I get that with out a loop ? there are multiple source files

6

not tested...

for FILE in *_ContractDocuments.csv
  { rm ${FILE}; awk -F, 'NF--' OFS=, > ${FILE}; } < ${FILE}
done