Shell Programming and Scripting

I have two files which have to be compared. One of them has leading & trailing zeroes in certain fields.

Code:

file1
----
John,Rambo,20100101,2119.5,3302.39,100.07,22211.0
 
file2
----
John,Rambo,20100101,000002119.50,0003302.39,00000.07,000022211.00

I am thinking of using diff to compare these files but that would need removing the leading and trailing zeroes. I have been able to remove the leading zeroes. Its the other part where i am stuck

How can i convert .50 to .5 / .00 to .0 & leave .39 as .39 / .07 as .07 ? This is column specific.

---------- Post updated at 05:10 AM ---------- Previous update was at 05:03 AM ----------

Converting .00 to .0 is done. Now i need to see how to convert .X0 to .X

Code:

awk 'BEGIN {OFS=FS=","} {if($7) sub(/\.00/,"\.0"); print}' infile

Try:

Code:

awk -F, -vOFS="," '{for (i=1;i<=NF;i++)sub("0$","",$i)}1' infile

shorter:

Code:

awk '{gsub("0,",",");sub("0$","")}1' infile

@bartus11 These are removing everything after decimal i.e changing 5.0 to 5. Converts 5.20 to 5.2 & 5.0 to 5.

Try:

Code:

perl -pe 's/(\..)0,/\1,/g;s/(\..)0$/\1/' infile

Cannot use perl unfortunately. Can you please suggest an awk/sed solution ?

Code:

sed 's/\(\..\)0,/\1,/g;s/\(\..\)0$/\1/' infile

@bartus11 Thanks it worked fine. But there is another problem with the method i used to remove leading zeroes. It is removing the entire ine when the colum has only zeors i.e. instead of converting the data from 0000000.00 to 0.0, the command is removing all the rows having 0000000.00 in the column being looked for. Why is this happening ? Any alternate soln ?

Here is the method i used to remove leading zeros

Code:

awk -F, '$7=sprintf("%.2f", $7)' OFS=, infile