shell - Remove trailing zeros in a file except character

Question

I have the following values in my file:

1.5000
0.006
9.0001
104.2500
17.0000
3.5000
paper

I want to remove the trailing zero, the following awk will remove the trailing zeros but print zeros for character value:

awk '{a=$0+0;if (a!~/./) a=a".0";print a}' file

Output of above awk:

1.5
0.006
9.0001
104.25
17
3.5
0.0

How to modify the awk to skip the characters?

Excepted output:

1.5
0.006
9.0001
104.25
17.0
3.5
paper

Answer 1

Using sed:

sed 's/,([0-9]*[.]0?)((0*[1-9]+)*)0*/,12/' input

This gives:

1.5
0.006
9.0001
104.25
17.0
3.5
paper

For a multi-column file:

awk '$2~/^[0-9]+[.][0-9][1-9]*0+$/{
     $2=gensub(/([.]0?([0-9]*[1-9]+)?)0*$/, "\1", "g", $2)}1' input