Shell Programming and Scripting

How do I trim the leading zeroes, and (+,-) in the currency field ?

I have a text file.
Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06.
Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06.

I want the O/P file to be like.
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.

One of the possible ways I cud think was to write a small function to read char by char and remove the leading zeroes. Is there any other quicker and effcient way ?

Any suggestions ?

Thanks.

one way

Code:

awk '$4 ~ /^+/{ sub(/^\+0+/,"",$4) }{print $0}' "file"

output:

Code:

# ./test1.sh
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.

Try...

Code:

awk '$4+=0' file

Dear ghostdog74,

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

Thanks in advance
Regards,
Pankaj

x=+00002780.96
num=$(( ${x} ))
echo $num

Try this too

sed '/[+-]/,/[1-9]/ s/[+-]00*//g' file

This sed statement would modify the date too since the '-' symbol is present in the date representation