『楼 主』:
[求助]提取文本指定行内容
有一文本文件a.txt,内容有上万条内容,其中一部份如下:
G101,1090023001,200706,30,20000,20000229,0,20000
G101,1090023001,200707,31,20000,20000229,0,20000
G101,1090023001,200708,31,20000,20070731,20000,0
G101,1090023002,200705,31,10000,20000427,0,10000
G101,1090023002,200706,30,10000,20000427,0,10000
G101,1090023002,200707,31,10000,20000427,0,10000
G101,1090023002,200708,31,10000,20070731,10000,0
G101,930000109024540000,200703,31,0,20060427,0,50000
G101,930000109024540000,200812,31,50000,20070731,0,30000
G101,930000109024540000,200901,31,50000,20070731,0,30000
G101,54110118047141,200708,31,0,20070706,0,80000
……
以每行的第二列(以逗号为分隔符)数据比较下一行第二列的数据,如果不相同则提取该行到b.txt,与下一行第二列的数据相同则不提取。提取b.txt后的结果如下:
G101,1090023001,200708,31,20000,20070731,20000,0
G101,1090023002,200708,31,10000,20070731,10000,0
G101,930000109024540000,200901,31,50000,20070731,0,30000
即是有红字所在行。
求大家帮帮忙!
|