Shell Programming and Scripting

awk -F "," '{printf $amount}'

awk '{$3=sprintf(curfmt,$3)}1' FS=, OFS=, curfmt="$%'.2f" file

awk '{printf fmt, $1, $2, $3, $4}' FS=, fmt="%s,%s,$%'.2f,%s\n" file

$ echo 0,2,10000,c | awk '{$3=sprintf(curfmt,$3)}1' FS=, OFS=, curfmt="$%'.2f" 
0,2,$10,000.00,c

BEGIN{
  FS=OFS=","
}

{
  $3=sprintf("$%'.2f",$3)
}
1

awk -f test.awk file

# cookbook filename: func_commify
# bash cookbook, Albig, et al, Page 450.

function commify {
    typeset text=${1}

    typeset bdot=${text%%.*}
    typeset adot=${text#${bdot}}

    typeset i commified
    (( i = ${#bdot} - 1 ))

    while (( i>=3 )) && [[ ${bdot:i-3:1} == [0-9] ]]; do
        commified=",${bdot:i-2:3}${commified}"
        (( i -= 3 ))
    done
    echo "${bdot:0:i+1}${commified}${adot}"
}

commify 1000

1,000

OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian 5.0.8 (lenny, workstation) 
bash GNU bash 3.2.39

$ LANG="en_US.UTF-8" awk -v fmt="%'d\n" -v amount=10000 'BEGIN{printf fmt, amount}'
10,000
$ LANG="C" awk -v fmt="%'d\n" -v amount=10000 'BEGIN{printf fmt, amount}'
10000
$ LANG="de_DE.UTF-8" awk -v fmt="%'d\n" -v amount=10000 'BEGIN{printf fmt, amount}'
10000

LANG="en_US.UTF-8" awk -v fmt="%'d\n" -v amount=10000 'BEGIN{printf fmt, amount}'
awk: run time error: improper conversion(number 1) in printf("%'d
")
    FILENAME="" FNR=0 NR=0