Replace Pioneer Home All Examples Free Download

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

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