取得为空的行

我不重要

INSERT INTO addrpool VALUES(1,'test',2,'1.1.1.1','1.1.1.2','',' ',0);
INSERT INTO addrpool VALUES(2,'pl',1,'2.2.2.2','255.255.255.254','test',' ',0);
INSERT INTO addrpool VALUES(3,963,2,'3.3.3.3','3.3.3.4','asdasdsadads7a8',' ',0);
INSERT INTO addrpool VALUES(4,'asdasd',2,'4.4.4.2','4.4.4.3','oasd_',' ',0);
INSERT INTO addrpool VALUES(5,656,2,'4.4.4.5','4.4.4.6','',' ',0);
INSERT INTO addrpool VALUES(6,'dasdasd',2,'5.5.5.1','5.5.5.2','32-',' ',0);

各位大神，我想取得倒数第三列为空的行，该怎么取，试了好多，老报错

Herowinter

1. awk -F, '$(NF-2)=="\047\047"' i
   
2. INSERT INTO addrpool VALUES(1,'test',2,'1.1.1.1','1.1.1.2','',' ',0);
   
3. INSERT INTO addrpool VALUES(5,656,2,'4.4.4.5','4.4.4.6','',' ',0);

复制代码

聆雨淋夜

awk -F, '$(NF-2)=="\047\047"' file

我是一隻羊

1. sed -rn "/'','[^']+'[^']+$/p" inputfile

复制代码

bikong0411

1. awk  -vFS=','   '$(NF-2)== "'"''"'"'  urfile

复制代码

，好看些的话就用\047