我有如下文本:
Symbol,Date,Time,Close,Volume,Amount,MartchItem,BSFlag,BidPrice0,BidPrice1,BidPrice2,BidPrice3,BidPrice4,BidPrice5,BidPrice6,BidPrice7,BidPrice8,BidPrice9,nAskPrice0,nAskPrice1,nAskPrice2,nAskPrice3,nAskPrice4,nAskPrice5,nAskPrice6,nAskPrice7,nAskPrice8,nAskPrice9,BidVolume0,BidVolume1,BidVolume2,BidVolume3,BidVolume4,BidVolume5,BidVolume6,BidVolume7,BidVolume8,BidVolume9,AskVolume0,AskVolume1,AskVolume2,AskVolume3,AskVolume4,AskVolume5,AskVolume6,AskVolume7,AskVolume8,AskVolume9
SZ000001,20100105,91514314,0.0,0,0,0, ,237100,0,0,0,0,0,0,0,0,0,237100,0,0,0,0,0,0,0,0,0,8000,0,0,0,0,0,0,0,0,0,,8000,5101,0,0,0,0,0,0,0,0
SZ000001,20100105,91542342,0.0,0,0,0, ,237100,0,0,0,0,0,0,0,0,0,237100,0,0,0,0,0,0,0,0,0,9500,0,0,0,0,0,0,0,0,0,,9500,3601,0,0,0,0,0,0,0,0
SZ000001,20100105,91632392,0.0,0,0,0, ,237100,0,0,0,0,0,0,0,0,0,237100,0,0,0,0,0,0,0,0,0,10500,0,0,0,0,0,0,0,0,0,,10500,5451,0,0,0,0,0,0,0,0
第一行是标题行,下面的是具体的数据。但是下面的数据多出了一列出现了两个逗号相连的情况:这种", ,"是正确的数据;这种",,"是不正确的数据。我希望把后面的那种情况的第二个逗号删除。请问用AWK如何操作。谢谢 |