How to trim the leading zeroes in a Currency field ?

Amruta Pitkar · #1 (**permalink**) 05-29-2007

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.

ghostdog74 · #2 (**permalink**) 05-29-2007

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.

suparnbector · #3 (**permalink**) 05-29-2007

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

praveenkumar_l · #4 (**permalink**) 05-29-2007

Try this too

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

lorcan · #5 (**permalink**) 05-29-2007

Quote:

Originally Posted by praveenkumar_l

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

praveenkumar_l · #6 (**permalink**) 05-29-2007

Quote:

Originally Posted by lorcan

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

I have corrected my sed command. Try this. It is working fine.

sed 's/[+-]00*$.*\..*$/\1/g' file

Ygor · #7 (**permalink**) 05-29-2007

Try...

Code:

awk '$4+=0' file

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
trim leading zero in certain column in a string	dngo	UNIX for Dummies Questions & Answers	2	04-01-2007 03:30 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: