Multiple columns replace with null values.
I am trying to replace the partcular columns(Col3,col5,col20,col44,col55,co56,col59,col60,col61,col62,col74,col75,col88,col90,col91,col93 ,col94,col95) with empty
Input file
Col1,col2,col3,col4,col5------,col100
1,2,3,4,5,---------,100
3,4,5,6,7,---------,300
Output :
Col1,col2,col3,col4,col5------col100
1,2,,4,,---------100
3,4,,6,,---------300
Tried with sed but not working.
sed command not helping because I am replacing the entire column with null value.
"The scenario simply replace few columns with null values in a file."
Any advices on sed command to replace the entire column as null.