split a csv into multiple files based on column value

227 views
Skip to first unread message

Zizi Jama

unread,
Apr 3, 2018, 8:32:23 AM4/3/18
to OpenRefine
I have a csv file with no headers

1,a,b
2,a,c,e,f
1,a,b
2,a,c,e,f
1,a,b
2,a,c,e,f
3,v.c

I would like to split by first column so that I can then have 3 separate files

1,a,b
1,a,b
1,a,b

2,a,c,e,f
2,a,c,e,f
2,a,c,e,f

3,v.c

Thanks

Ettore Rizza

unread,
Apr 3, 2018, 9:03:45 AM4/3/18
to OpenRefine
Hi,

You will have to do this manually (screencast). 





OpenRefine does not yet have a feature that automates facet export to CSV. If it's an essential functionality for you, you can open a new issue.

Hope this helps,

Ettore
Reply all
Reply to author
Forward
0 new messages