awk的printf能输出千位符格式么

rm-rf

比如123456789.12 输出格式为123,456,789.12

jason680

回复 1# rm-rf

$ echo 123456789.12 | awk '{printf("%\x27.2f\n",$1)}'
123,456,789.12

rm-rf

回复 2# jason680

什么都没有发生。

1. $ echo 123456789.12 | awk '{printf("%\x27.2f\n",$1)}'
   
2. 123456789.12
   
3. 
   
4. $ awk --version
   
5. GNU Awk 4.1.4

复制代码

rm-rf

明白了，好像与locale有关

1. $ LC_ALL="en_US" awk 'BEGIN{printf("%'"'"'.2f\n",123456789.12)}'
   
2. 123,456,789.12
   

复制代码

https://www.gnu.org/software/gaw ... rmat-Modifiers.html

A single quote or apostrophe character is a POSIX extension to ISO C. It indicates that the integer part of a floating-point value, or the entire part of an integer decimal value, should have a thousands-separator character in it. This only works in locales that support such characters. For example:

$ cat thousands.awk          Show source program
-| BEGIN { printf "%'d\n", 1234567 }
$ LC_ALL=C gawk -f thousands.awk
-| 1234567                   Results in "C" locale
$ LC_ALL=en_US.UTF-8 gawk -f thousands.awk
-| 1,234,567                 Results in US English UTF locale

rm-rf

明白了，好像与locale有关

1. $ LC_ALL="en_US" awk 'BEGIN{printf("%'"'"'.2f\n",123456789.12)}'
   
2. 123,456,789.12
   

复制代码

https://www.gnu.org/software/gaw ... rmat-Modifiers.html

A single quote or apostrophe character is a POSIX extension to ISO C. It indicates that the integer part of a floating-point value, or the entire part of an integer decimal value, should have a thousands-separator character in it. This only works in locales that support such characters. For example:

$ cat thousands.awk          Show source program
-| BEGIN { printf "%'d\n", 1234567 }
$ LC_ALL=C gawk -f thousands.awk
-| 1234567                   Results in "C" locale


$ LC_ALL=en_US.UTF-8 gawk -f thousands.awk
-| 1,234,567                 Results in US English UTF locale

moperyblue

1. echo 123456789.12 |sed -r ':a;/^.{1,3},/b;s/...[.,]/,&/;ta'

复制代码

sunzhiguolu

1. perl -pe "@F=split(/\./);$F[0]=~s/(?<=\d)(?=(\d{3})+\b)/,/g;$_=join(q(.),@F)" f

复制代码

jason680

回复 3# rm-rf

gawk manual for you
https://www.gnu.org/software/gawk/manual/gawk.htm

rm-rf

jason680 发表于 2017-03-26 12:34
回复 3# rm-rf

gawk manual for you

原来是这样

1. $ LC_ALL="en_US" awk 'BEGIN{printf("%\x27.2f",123456789.12)}'
   
2. 123,456,789.12

复制代码

zy86416779

1. [root@CentOS_6 shell]# echo "123456789.12" | awk -F "" 'BEGIN{flag=1}{for(i=1;i<=NF;i++){printf $i;if(flag<=2){if(i%3==0){printf ",";flag+=1}}}printf "\n"}'
   
2. 123,456,789.12

复制代码