最近JAVA項(xiàng)目中碰到一個(gè)CSV數(shù)據(jù)分隔的問題,其中包含字符類型與數(shù)值類型及空值,字符類型帶雙引號(hào),數(shù)值類型不帶雙引號(hào),且個(gè)別字符字段中還包含了分隔符“,”。
"800802","127.0.0.1",,"caller",0.0,0,,,103,"MCX-1:123,MCX-2:660",-1,""
如何寫正則表達(dá)式將其正確的分隔成
"800802"
"127.0.0.1"
"caller"
0.0
0
103
MCX-1:123,MCX-2:660
-1
查閱了很多資料,沒有嘗試成功,請(qǐng)高手指點(diǎn),謝謝!