Dear ghostdog74,

can you please explain the function of
~ and sub(/^\+0+/,"",$4) in your code?

Thanks in advance
Regards,
Pankaj

you can try ygor's method.

Dear Ghostdog74,

i have tried ygor's method its working fine...
but i want to know the function of ~ there...please explain...

Thnks,
Regards,

Actually, there is a precision error in mine. You would need to set CONVFMT to fix...

$ awk '$4+=0' file
Your bill of 2780.96 for a/c no. 25287324 is due on 11-06.
Your bill of 422270 for a/c no. 28931373 is due on 11-06.
$ awk -v CONVFMT='%.2f' '$4+=0' file
Your bill of 2780.96 for a/c no. 25287324 is due on 11-06.
Your bill of 422270.48 for a/c no. 28931373 is due on 11-06.
$

Hello ghostdog
Can u please explain ur awk script ?

Thanks.

in your sample file, the currency value is in the 4th field.
/^\+0+/ : means match the start with literal + sign and then one or more 0's. (the '+' sign after the 0).
sub(/^\+0+/,"",$4) : means if $4 matched, substitute with "", meaning null..ie it removes them...

Hello ghostdog74

I get the follow. error when I try to implement ur awk script.

awk: 0602-521 There is a regular expression error.
*?+ not preceded by valid expression
The source line number is 1.
The error context is
$4 ~ >>> /^+/{ <<<

Pls. guide.