Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

879.Text file splitter -- How to split a csv file into multiple files according to value of column B?

User: editor -- 2011-10-25          << 878  880 >>
Hits: 4099
Type: Text file splitter   
Search all Text file splitter examples
Description:
How to split a csv file into multiple files according to value of column B, and use value of column B as filename?
Input Sample:
AA,Tommy
BB,Tommy
CC,Tommy
XX,Jerry
YY,Jerry
AA,Lucy
UU,Lucy
VV,Lucy
Output Sample:
Splitting to:
===========
Tommy.csv
AA,Tommy
BB,Tommy
CC,Tommy
===========
Jerry.csv
XX,Jerry
YY,Jerry
===========
Lucy.csv
AA,Lucy
UU,Lucy
VV,Lucy
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
Note: version 2.68 or newer is required for procedures below.
1. ctrl-o open csv file
2. open "File->Save As->Split by Paragraph" menu
* set "split naming" to:

* set "Para start" to other:

* set "Para end" to 'none'
3. click "Next" button, and select a new output filename in destination folder, all required files will be generated.

Similar Examples:
How to split a csv file according to the value of column A? (80%)
How to split a CSV file with Header according to value of  column B? (77%)
How to split a CSV file with Header according to value of a column? (75%)
How to substract one csv file from another according to value of column A? (72%)
How to split a file into many files according to first letter of each line? (71%)
How to split a text file into multiple files evenly on size? (68%)
How to split a file into two parts according to the content of line? (67%)
How to split a text file into multiple files and take the date as filename? (66%)

Check Demo of Text file splitter
Keywords:
how to split a csv file into multiple files according to value of column  how to split a csv file into multiple files  firstline  previous  split naming  split by paragraph  how to split a csv  split a csv file  how to split a csv file  naming  split csv file into multiple files by column value  split csv by column value to multiple files  split csv file into multiple files column  split csv file into multiple files by column  split csv file by value in column  split files according to column value  split csv file by value  csv splitter by value