AWK Currency Conversion

3junior · March 21, 2009, 2:10pm

How can I use awk command to convert values to currency. For example I have a database like follows
John:200
smith:300
kim:405

and want it to out put like this
John $200.00

vgersh99 · March 21, 2009, 2:40pm

nawk -F: '{print $1, "$" $2} OFS=' ' myFile

3junior · March 21, 2009, 2:43pm

What if it was like
John:200.4
smith:300.50
kim:405.60
How can i make it so all the outputs will be in format $0.00

vgersh99 · March 21, 2009, 3:38pm

nawk -F: '{printf("%s%s$%.2f\n", $1, OFS, $2)}' OFS=' ' myFile