很多时候， csv 文件不一定使用逗号做为分隔符。
如果你使用 apache 的 Commons CSV 处理 csv 文件，你可以用下面的方法设置分隔符。Iterable<CSVRecord> parser = CSVFormat.DEFAULT.withCommentStart('#').withDelimiter('\t').parse(new FileReader(fileName));这个格式可以用于处理 csv 文件用 tab 作为分隔符。
需要处理的原始 csv 文件如下:DCMD 7647 ABC Realtors Off market 1263 395283 John Doe 4107841 4741 Annhurst Rd Columbus OH 43228 99787 0 0 0 0 3/7/2013
DCMD 7647 ABC Realtors Off market 1263 406627 John Doe 4118993 5141 Grandon Dr Hilliard OH 43026 134900 12 0 1 0 0 3/1/2013
DCMD 7647 ABC Realtors Off market 1263 2001004799 John Doe 2821810 5600 High Arbor Dr Galloway OH 43119 158900 18 0 1 0 0 3/1/2013
DCMD 7647 ABC Realtors Off market 1263 292719 John Doe 2821117 5833 Heritage Lakes Dr Hilliard OH 43026 434900 0 3 0 0 3/7/2013
DCMD 7647 ABC Realtors Off market 1263 406627 John Doe 2821553 5901 SCIOTO PKWY Powell OH 43065 399999 0 0 0 0 3/4/2013
DCMD 7647 ABC Realtors Off market 1263 292719 John Doe 4043516 5994 Heritage View Ct Hilliard OH 43026 449900 25 0 1 0 0 3/2/2013
DCMD 7647 ABC Realtors Off market 1263 292719 John Doe 4107842 6229 Barley Oaks Rd Hilliard OH 43026 270000 18 0 3 0 0 3/1/2013
DCMD 7647 ABC Realtors Off market 1263 395283 John Doe 2825257 6622 Birch Park Way Galloway OH 43119 95900 16 0 1 0 0 3/3/2013
DCMD 7647 ABC Realtors Off market 1263 327177 John Doe 4107392 678 Prairie Rd Galloway OH 43119 145900 20 0 2 0 0 3/2/2013
DCMD 7647 ABC Realtors Off market 1263 292719 John Doe 2824868 7225 Springview Ln Dublin OH 43016 339900 0 1 0 0 3/3/2013
DCMD 7647 ABC Realtors Off market 1263 2001004799 John Doe 2821281 76 East 5th St London OH 43140 110000 17 0 1 0 0 3/5/2013
DCMD 7647 ABC Realtors Off market 1263 301937 John Doe 2818101 8825 Riebel Rd Galloway OH 43119 299900 18 0 1 0 0 3/5/2013
DCMD 7647 ABC Realtors Off market 1263 301937 John Doe 2818783 8825 Riebel Rd Galloway OH 43119 299900 18 0 5 0 0 3/4/2013
DCMD 7647 ABC Realtors Off market 1263 406627 John Doe 2818185 8900 Oak Ridge Ln Plain City OH 43064 349900 0 1 0 0 3/3/2013
DCMD 7647 ABC Realtors Off market 1263 301937 John Doe 4107816 9280 Alkire Rd Grove City OH 43123 349900 12 0 8 0 0 3/1/2013
DCMD 7649 ABC Realtors For sale 1263 387328 John Doe 4106622 GRANDVIEW DR THORNVILLE OH 43076 25000 8 0 3 0 0 3/5/2013
for (CSVRecord record : parser) {
System.out.println(record.get(7));
}将会输出第 7 列的内容。