文本中某一字段重复交替出现,重复的只保留首次出现的,求解!

sh/bash/dash/ksh/zsh等Shell脚本
回复
oeasy
帖子: 2
注册时间: 2010-05-31 21:25

文本中某一字段重复交替出现,重复的只保留首次出现的,求解!

#1

帖子 oeasy » 2011-05-08 0:27

有如下格式文本数据,以“,”做字段分隔符,第5个字段总是
0,1交替出现
粤BA0P72,2011/04/18 00:12:43,114.060020,22.551399,1,45,5,
粤BA0P72,2011/04/18 00:22:14,114.039413,22.563200,1,55,1,
粤BA0P72,2011/04/18 00:23:24,114.049019,22.564251,0,42,3,
粤BA0P72,2011/04/18 00:23:44,114.049187,22.564234,0,0,3,
粤BA0P72,2011/04/18 00:31:32,114.085999,22.567667,1,49,3,
粤BA0P72,2011/04/18 00:31:47,114.086365,22.567167,1,33,2,
粤BA0P72,2011/04/18 00:32:32,114.084801,22.570999,1,28,7,
粤BA0P72,2011/04/18 00:35:30,114.094734,22.569983,0,0,2,
粤BA0P72,2011/04/18 00:35:50,114.094635,22.570017,0,0,2,

比如第一行第5个字段是1,那么接下来相同字段出现1的就删除,出现0时也
同样处理,处理后的理想结果如下:
粤BA0P72,2011/04/18 00:12:43,114.060020,22.551399,1,45,5,
粤BA0P72,2011/04/18 00:23:24,114.049019,22.564251,0,42,3,
粤BA0P72,2011/04/18 00:31:32,114.085999,22.567667,1,49,3,
粤BA0P72,2011/04/18 00:35:30,114.094734,22.569983,0,0,2,

求解!!!
回复