I have a file of the formVL-8299673,30.000,49.000,1.000,21.901,2630.000,428861.000VL-8299673,1071.000,570.000,35.000,3963.608,632.000,366563.000VL-8299673,36.000,867.000,24.000,6523.005,3544.000,176054.000VL-8299673,5:281185.000VL-8299673,44.000,372.000,67.000,7029.358,293.000,446448.000VL-8299673,5:48479.000VL-8299673,0:2.000,2:7.000,3:80.222,4:1153.000it is supposed to be of the formVL-8299673,1190.000,609.000,28.000,12676.158,1819.000,452813.000but when there are zeros in the file it only shows the column numbers that are nonzero such asVL-8299673,0:2.000,2:7.000,3:80.222,4:1153.000I would like to write a sed command that makes a 7 length row with zeros included such as VL-8299673,2.000,0,7.000,80.222,1153.000,0Any ideas?
sed into csv format
sed