关于awk包含空格以及=做为分隔符的问题！

luck_libiao

回复 8# lkk2003rty


    没有报错的！不过也少了一个｝
awk -F  "[= ]" '{ a[$8]++} END{for (b in a) {print b,a} }' billtype_Mem.sql 执行的结果为：
55434744 1
56604049 1
10735231 1
54653178 1
55917492 1
11433573 1
53102121 1
56628142 1
10103998 1
53956299 1
54852113 1
55486244 1
56056673 1
56391452 1
54254460 1
50775650 1
53102118 1
53420560 1
56783193 1
54653202 1
54022999 1
54016439 1
10337832 1
50369194 1
但是我之前执行却没有结果，汗。。。
当时是想测试下：awk -F "[= ]" ' BEGIN { OFS=" " } {print }' billtype_Mem.sql  ;但是并没有按 空格做为分隔符来输出！
还是输出原数据！

howge

回复 1# luck_libiao


    awk -F  "=| " '{ a[$8]++} END{for (b in a) {print b,a} }' file
这样可以吗？


重新编辑了，语法错误吧！！ 你少个 “}”

lkk2003rty

回复 11# luck_libiao

1. [oracle@s12071 ~]$ awk -F "[= ]" '{a[$8]++}END{for(cnt in a)print cnt,a}' file
   
2. awk: cmd. line:1: (FILENAME=file FNR=8) fatal: attempt to use array `a' in a scalar context
   
3. [oracle@s12071 ~]$ awk --version
   
4. GNU Awk 3.1.3
   
5. Copyright (C) 1989, 1991-2003 Free Software Foundation.
   
6. 
   
7. This program is free software; you can redistribute it and/or modify
   
8. it under the terms of the GNU General Public License as published by
   
9. the Free Software Foundation; either version 2 of the License, or
   
10. (at your option) any later version.
    
11. 
    
12. This program is distributed in the hope that it will be useful,
    
13. but WITHOUT ANY WARRANTY; without even the implied warranty of
    
14. MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    
15. GNU General Public License for more details.
    
16. 
    
17. You should have received a copy of the GNU General Public License
    
18. along with this program; if not, write to the Free Software
    
19. Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
    
20. [oracle@s12071 ~]$

复制代码

lkk2003rty

回复 11# luck_libiao


    如果有空格分隔符你覺得應該是什麽樣的。。。。。。。。。

ywlscpl

awk -F "subscriberkey=" '{split($2,m," +");a[m[1]]++}END{for (j in a) print j,a[j]}' file

luck_libiao

回复 13# lkk2003rty


    但是在我的Unix系统上是可以运行的：
awk -F  "[= ]" '{ a[$8]++} END{for (b in a) {print b,a} }' billtype_Mem.sql
55434744 1
56604049 1
10735231 1
54653178 1
55917492 1
11433573 1
53102121 1
56628142 1
10103998 1
53956299 1
54852113 1
55486244 1
56056673 1
56391452 1
54254460 1
50775650 1
53102118 1
53420560 1
56783193 1
54653202 1
54022999 1
54016439 1
10337832 1
50369194 1

luck_libiao

回复 11# luck_libiao


    怎么我写的东西，少了[]号呢！原语句在附件的图中！

luck_libiao

回复 12# howge


    这样也是可以的！貌似使用awk的通配符和[]均是可以的，awk还有很多值得专研的东西！