我有一個(gè)這樣的csv文件"5478",a,56.40,-0.40 ,55.50,57.50,55.30,56.74,"862,971","48,962,460","695",56.40,56.60,"127,474,332",56.40,60.30,52.50"5480",b,21.90,-0.25 ,21.80,22.00,21.80,21.87,"1,598,041","34,950,597","590",21.90,21.95,"199,097,830",21.90,23.40,20.40"70462P",c,0.01,-0.01 ,0.01,0.01,0.01,0.01,"99,000","990","1",0.01,0.06,"5,000,000",0.01,0.31,0.01"70465P",d, ---,--- ,---,---,---,0.02,"0","0","0",0.01,0.03,"20,000,000",0.02,0.32,0.01"8935",bt,5.02,-0.02 ,4.95,5.19,4.92,5.05,"949,102","4,791,070","290",5.02,5.07,"201,902,107",5.02,5.37,4.671333,tnd,21.40,-0.60 ,22.00,22.20,21.20,21.52,"1,519,292","32,692,804","631",21.40,21.50,"102,525,625",21.40,22.85,19.95我想檢查第一列（如果超過4位數(shù)字），然后刪除該行，例如，第二行和第三行將被刪除。我該怎么做呢？多謝ps2這是從股票中心下載的股票信息，但是我發(fā)現(xiàn)格式最近發(fā)生了變化，之前的格式是最后一行，第一列沒有引號(hào)“”，是否可以過濾這兩種格式？還是我應(yīng)該處理這兩種情況？
3 回答
交互式愛情
TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個(gè)贊
這是一個(gè)sed解決方案：
sed -e '/^"[0-9]\{5\}/d' in-file > out-file您還可以使用-i選項(xiàng)進(jìn)行就地替換：
sed -i -e '/^"[0-9]\{5\}/d' file
瀟湘沐
TA貢獻(xiàn)1816條經(jīng)驗(yàn) 獲得超6個(gè)贊
不確定您要使用哪種語言，因?yàn)槟鷺?biāo)記了awk并在標(biāo)簽中添加了sed，但是您可以簡(jiǎn)單地使用grep：
egrep '^\"[0-9]{1,4}\"' file.txt
墨色風(fēng)雨
TA貢獻(xiàn)1853條經(jīng)驗(yàn) 獲得超6個(gè)贊
awk
awk -F, '$1~ /^\"[0-9][0-9]?[0-9]?[0-9]?\"$/' file
GNU sed
sed '/^\"[0-9]\{1,4\}\"/!d' file添加回答
舉報(bào)
0/150
提交
取消