How to calculate with awk

whatisthis · #1 (**permalink**) 11-09-2005

Hi,
I have below awk statement and I need to convert the second field ( substr($0,8,6))from minutes to hours with 2 decimail place. How can I achieve this?

/usr/bin/awk '{print substr($0,23,4),substr($0,8,6)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$

Thanks for any help!

vgersh99 · #2 (**permalink**) 11-09-2005

might be helpful to see a sample of your '$0'

whatisthis · #3 (**permalink**) 11-09-2005

It's
DD0300312310250588 CA8440300444 220

vgersh99 · #4 (**permalink**) 11-09-2005

Code:

/usr/bin/nawk '{printf("%s%s%.2f\n", substr($0,23,4), OFS, substr($0,8,6) / 60)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$

whatisthis · #5 (**permalink**) 11-09-2005

Thank you soooo much for your quick reply!!!!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How To Calculate	krishna_sicsr	Shell Programming and Scripting	3	03-21-2009 01:49 PM
How to calculate the maximum value & min value	gobinath	Shell Programming and Scripting	1	05-29-2008 12:01 AM
calculate 13 months ago	andrea_mussap	Shell Programming and Scripting	3	11-16-2007 03:18 PM
how do I calculate percentage ?	the_learner	High Level Programming	6	04-18-2007 04:40 PM
How To Calculate Data	krishna_sicsr	Shell Programming and Scripting	0	03-25-2007 02:35 AM

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