awk - arithemetic functions with external variables

DKNUCKLES · #1 (**permalink**) 11-30-2007

I'm trying to get awk to do arithmetic functions with external variables and I'm getting an error that I cannot figure out how to fix.

Insight would be appreciated

Code:

        money=$1
        rate1=$(awk -F"\t " '/'$converting'/{print $3}' convert.table)
        rate2=$(awk -F"\t" '/'$converted'/{print $3}' convert.table)
        awk -F"\t" '{printf '$rate2'/'$rate1'*'$money'}'

fpmurphy · #2 (**permalink**) 12-01-2007

You cannot pass external variables into awk in the manner that you are attempting to use.

Try:

Code:

awk -F"\t" -v rate1=$rate1 -v rate2=$rate2 -v money=$money '{print rate2/rate1*money}'

prowla · #3 (**permalink**) 12-01-2007

I'm not at a UNIX machine now, but this should work:

Code:

        money=$1
        rate1=$(awk -F"\t " '/'$converting'/{print $3}' convert.table)
        rate2=$(awk -F"\t" '/'$converted'/{print $3}' convert.table)
        awk -F"\t" '{printf r2/r1*m}' r2=$rate2 r1=$rate1 m=$money

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Problem in arithemetic operation	subin_bala	Shell Programming and Scripting	3	04-23-2008 11:47 AM
Use of functions	amitrajvarma	Shell Programming and Scripting	1	11-23-2007 06:52 AM
How to parse config variables from external file to shell script	pradsh	Shell Programming and Scripting	2	07-09-2007 03:21 PM
Variables and functions	dfb500	Shell Programming and Scripting	4	05-21-2007 05:23 PM
arithemetic problem	anujairaj	UNIX for Dummies Questions & Answers	9	05-01-2006 12:55 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:


	Powered by