关于提取连续长度字符

Qiangxi

以,为分隔符的数据，如果第三列中包含了连续长度超过5位的（0-9数字）的记录，则提取所在行

sddsfs,sdfjdfgdfg,123,iuoi
sddsfs,sdfjdfgdfg,123456,iuoi
sddsfs,sdfjdfgdfg,A123456B,iuoi
sddsfs,sdfjdfgdfg,aaaaaaa,iuoi

提取
sddsfs,sdfjdfgdfg,123456,iuoi
sddsfs,sdfjdfgdfg,A123456B,iuoi

这个如何用awk或grep实现，哪个效率更好

Herowinter

回复 1# Qiangxi

目测是这样，可以吗？

grep -P "^([^,]*,){2}[^,]*[0-9]{6,}" urfile


   

Qiangxi

Herowinter 发表于 2015-01-24 15:09
回复 1# Qiangxi

目测是这样，可以吗？

感谢，测试后可以
再追加一下，如果是第三列或第四列包含了连续长度超过5位的（0-9数字）的记录，该怎么提取

sky_eminem

awk 'BEGIN{FS=","}{if(length($3)>5 || length($4)>5){print $0}}' inputfile | grep "[0-9]\{5,\}"

liion631818

回复 3# Qiangxi


    能告诉我你们搞这些脚本都是干什么工作的吗？好像对编程的要求又不高啊

rulebook

1. awk -vFS=',' '$3~/[0-9]{5}/' o

复制代码

PS：

1. [root@salt sh]# awk -V
   
2. GNU Awk 4.0.2
   
3. Copyright (C) 1989, 1991-2012 Free Software Foundation.
   
4. 
   
5. This program is free software; you can redistribute it and/or modify
   
6. it under the terms of the GNU General Public License as published by
   
7. the Free Software Foundation; either version 3 of the License, or
   
8. (at your option) any later version.
   
9. 
   
10. This program is distributed in the hope that it will be useful,
    
11. but WITHOUT ANY WARRANTY; without even the implied warranty of
    
12. MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    
13. GNU General Public License for more details.
    
14. 
    
15. You should have received a copy of the GNU General Public License
    
16. along with this program. If not, see http://www.gnu.org/licenses/.

复制代码

若awk4.0以下版本，{}不能直接使用，需+ --re-interval

Herowinter

回复 3# Qiangxi


    grep -P "^([^,]*,){2,3}[^,]*[0-9]{6,}" urfile

wmsok

[root@wmsvmpc ~]# cat sql.log
sddsfs,sdfjdfgdfg,123,iuoi
sddsfs,sdfjdfgdfg,123456,iuoi
sddsfs,sdfjdfgdfg,A123456B,iuoi
sddsfs,sdfjdfgdfg,aaaaaaa,iuoi
sddsfs,sdfjdfgdfg,a1234a1456a,iuoi
[root@wmsvmpc ~]#
[root@wmsvmpc ~]#
[root@wmsvmpc ~]#
[root@wmsvmpc ~]#  sed -n '/\(.*,\)\{2\}.*[0-9]\{6,\}.*/p' sql.log
sddsfs,sdfjdfgdfg,123456,iuoi
sddsfs,sdfjdfgdfg,A123456B,iuoi
[root@wmsvmpc ~]#

songyc_2015

1. awk --re-interval -F, '$3~/[0-9]{5,}/' f.txt

复制代码

A_Traveler

awk -vFS=',' 'length($3)>5&&$3~/[0-9]+/{print $0}' ufiles