rm -f lightning_indices_matlab.csv

echo "YYYY,MM,DD,HH,CAPE,CAPE_SFC,CAPE_UNST,CAPE_MXD,TPI" > lightning_indices_matlab.csv

awk -F, '(NR>1){printf("%4d,%02d,%02d,%02d,%.6f,%.6f,%.6f,%.6f,%.6f\n",substr($1,1,4),substr($1,6,2),substr($1,9,2),substr($1,12,2),$2,$3,$4,$5,$6);}' lightning_indices.csv >> lightning_indices_matlab.csv

head lightning_indices_matlab.csv
tail lightning_indices_matlab.csv

wc lightning_indices_matlab.csv