关于筛选

yxuqtr

[root@server ~]# cat sedfile
Steve Blenheim:238-923-7366:95 Latham Lane, Easton, PA 83755:11/12/56:20300
Betty Boop:245-836-8357:635 Cutesy Lane, Hollywood, CA 91464:6/23/23:14500
Igor Chevsky:385-375-8395:3567 Populus Place, Caldwell, NJ 23875:6/18/68:23400
Norma Corder:397-857-2735:74 Pine Street, Dearborn, MI 23874:3/28/45:245700
Jennifer Cowan:548-834-2348:583 Laurel Ave., Kingsville, TX 83745:10/1/35:58900
Jonathan DeLoach:408-253-3122:123 Park St., San Jose, CA 04086:7/25/53:85100
Karen Evich:284-758-2857:23 Edgecliff Place, Lincoln, NB 92086:7/25/53:85100
Karen Evich:284-758-2867:23 Edgecliff Place, Lincoln, NB 92743:11/3/35:58200
Karen Evich:284-758-2867:23 Edgecliff Place, Lincoln, NB 92743:11/3/35:58200
Fred Fardbarkle:674-843-1385:20 Parak Lane, DeLuth, MN 23850:4/12/23:780900
Fred Fardbarkle:674-843-1385:20 Parak Lane, DeLuth, MN 23850:4/12/23:780900
Lori Gortz:327-832-5728:3465 Mirlo Street, Peabody, MA 34756:10/2/65:35200
Paco Gutierrez:835-365-1284:454 Easy Street, Decatur, IL 75732:2/28/53:123500
Ephram Hardy:293-259-5395:235 CarltonLane, Joliet, IL 73858:8/12/20:56700
James Ikeda:834-938-8376:23445 Aster Ave., Allentown, NJ 83745:12/1/38:45000
Barbara Kertz:385-573-8326:832 Ponce Drive, Gary, IN 83756:12/1/46:268500
Lesley Kirstin:408-456-1234:4 Harvard Square, Boston, MA 02133:4/22/62:52600
William Kopf:846-836-2837:6937 Ware Road, Milton, PA 93756:9/21/46:43500
Sir Lancelot:837-835-8257:474 Camelot Boulevard, Bath, WY 28356:5/13/69:24500
Jesse Neal:408-233-8971:45 Rose Terrace, San Francisco, CA 92303:2/3/36:25000
Zippy Pinhead:834-823-8319:2356 Bizarro Ave., Farmount, IL 84357:1/1/67:89500
Arthur Putie:923-835-8745:23 Wimp Lane, Kensington, DL 38758:8/31/69:126000
Popeye Sailor:156-454-3322:945 Bluto Street, Anywhere, USA 29358:3/19/35:22350
Jose Santiago:385-898-8357:38 Fife Way, Abilene, TX 39673:1/5/58:95600
Tommy Savage:408-724-0140:1222 Oxbow Court, Sunnyvale, CA 94087:5/19/66:34200
Yukio Takeshida:387-827-1095:13 Uno Lane, Ashville, NC 23556:7/1/29:57000
Vinh Tranh:438-910-7449:8235 Maple Street, Wilmington, VM 29085:9/23/63:68900
需求是：显示所有生日在November-December之间的行
假设这部分为生日11/12/


想了用sed和awk都不行，最后用了很笨的办法：
[root@server ~]# grep :11/ sedfile --color >11
[root@server ~]# grep :12/ sedfile --color >12
[root@server ~]# cat 11 >>12
[root@server ~]# cat 12
James Ikeda:834-938-8376:23445 Aster Ave., Allentown, NJ 83745:12/1/38:45000
Barbara Kertz:385-573-8326:832 Ponce Drive, Gary, IN 83756:12/1/46:268500
Steve Blenheim:238-923-7366:95 Latham Lane, Easton, PA 83755:11/12/56:20300
Karen Evich:284-758-2867:23 Edgecliff Place, Lincoln, NB 92743:11/3/35:58200
Karen Evich:284-758-2867:23 Edgecliff Place, Lincoln, NB 92743:11/3/35:58200
这样搞定
不知各位大神有何高见

关阴月飞

回复 1# yxuqtr

以这行为代表，生日是这个不？？
    Steve Blenheim:238-923-7366:95 Latham Lane, Easton, PA 83755:11/12/56:20300


目测一下：

1. awk -F: '$(NF-1) ~ /^1[12]/' urfile

复制代码

dn833

1. grep  ':1[12]/'

复制代码

老狼000

1. awk -F":|/" '{if($4>=11){print $0}}' sr.txt
   

复制代码

yxuqtr

老关，你真是awk大神啊，关注你有段时间了，能加个QQ好友不？回复 2# 关阴月飞


   

yxuqtr

回复 2# 关阴月飞 如果说我还想将12/1/46这样的格式，改为出生日期，如1946-12-1
如何办？

   

关阴月飞

回复 6# yxuqtr


    有超过2000年以后出生的人不？

yxuqtr

回复 7# 关阴月飞

没有哦，好像我用date -d “xx/xx/xx” +%F都是2000年以后的。。。
不知您有啥办法
   

关阴月飞

回复 8# yxuqtr

确定都是在19xx年的话试试：

1. date -d "xx/xx/xx" +19%y-%m-%d

复制代码

yxuqtr

回复 9# 关阴月飞

这个是可以，但要是文本中有2000年后的呢，这该咋办？