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: 5177
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