# Commons CSV 的 CSVFormat 文件分割格式

**URL:** <https://www.isharkfly.com/t/commons-csv-csvformat/7012>\
**Category:** 程序语言\
**Created:** [June 10, 2013, 7:55pm UTC](https://www.isharkfly.com/t/commons-csv-csvformat/7012 "2013-06-10T19:55:10Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![honeymoose](https://www.isharkfly.com/user_avatar/www.isharkfly.com/honeymoose/32/20796_2.png) [@honeymoose](https://www.isharkfly.com/u/honeymoose)\
**Post date:** [June 10, 2013, 7:55pm UTC](https://www.isharkfly.com/t/commons-csv-csvformat/7012/1 "2013-06-10T19:55:10Z")

</div>

很多时候， 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`

 ![](https://com-ossez-www-discourse.s3.dualstack.us-east-2.amazonaws.com/discourse-uploads/original/2X/3/359eaf3c1f485e08319a0a758f664599e83e7e27.jpeg)`for (CSVRecord record : parser) {
System.out.println(record.get(7));
}`将会输出第 7 列的内容。