UNIX for Beginners Questions & Answers

CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860

Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86

awk -F, '
        {
                for( i = 1; i <= NF; i++ )
                {
                        if ( $1 ~ /\./ && $i !~ /[A-Za-z]/ )
                                sub( /0*$/, X, $i )
                }
        }
        1
' OFS=, file.csv

| rev | sed -r 's/(^|,)0+([1-9])([0-9]*)(.)([0-9]*)(,|$)/\1\2\3\4\5\6/' | rev

awk -F, '{for(i=1;i<=NF;i++){gsub(/^0+/,"",$i);if($i ~ /\.[0-9]/ && $i !~ /[a-zA-Z]/){gsub(/0+$|\.0+$/,"",$i)};}}1' OFS=,   Input_file

awk -F, '{
                for(i=1;i<=NF;i++){
                                        gsub(/^0+/,"",$i);
                                        if($i ~ /\.[0-9]/ && $i !~ /[a-zA-Z]/){
                                                                                gsub(/0+$|\.0+$/,"",$i)
                                                                              };
                                  }
         }
         1
        ' OFS=,   Input_file

000.5000a,0000.0000,a2.500200,0.5000,abc,2.00,2500,2.400,285.850,285a.850,205.1080800,mno000,a0b0,2.860,abc

.5000a,a2.500200,.5,abc,2,2500,2.4,285.85,285a.850,205.10808,mno000,a0b0,2.86,abc

000.5000a,a2.500200,.5,abc,2,2500,2.4,285.85,285a.850,205.10808,mno000,a0b0,2.86,abc

awk -F, '{for(i=1;i<=NF;i++){if($i ~ /\.[0-9]/ && $i !~ /[a-zA-Z]/){gsub(/0+$|\.0+$|^0+/,"",$i)};}}1' OFS=,   Input_file

awk -F, '{
                for(i=1;i<=NF;i++){
                                        if($i ~ /\.[0-9]/ && $i !~ /[a-zA-Z]/){
                                                                                gsub(/0+$|\.0+$|^0+/,"",$i)
                                                                              };
                                  }
         }
         1
        ' OFS=,    Input_file