|User: editor -- 2011-05-27 << 788 790 >>|
|Type: Text file splitter|
|Search all Text file splitter examples|
|How to split a csv file according to the value of column A? |
After splitting, need to use column A as filename. Note that the lines with same value in column A are adjacent.
|File: input.csv |
|File: user1.csv |
|Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.|
|1. ctrl-o open source csv file |
2. ctrl-h open 'replace' dialog
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:
* set 'If' to:
3. click 'Replace'
4. click "File-> SaveAs->Split by Paragraph" menu
* set "Para start" to "other", and set the following entry to:
* set "Para end" to "None"
5. click "Next", and input a filename in target folder, and click "Save", the csv file will be splitted to multiple csv files.
(Note: if you have installed "Replace Pioneer 2.68" or newer version, following easier example and answer is recommended:
Screenshot 1: Replace_Window
|How to split a CSV file with Header according to value of column B? (83%)|
How to split a CSV file with Header according to value of a column? (82%)
How to split a csv file into multiple files according to value of column B? (80%)
How to substract one csv file from another according to value of column A? (78%)
How to split a text file according to first word in each line? (68%)
How to batch sort csv files by the order of value in the specified column? (65%)
How to split a file into many files according to first letter of each line? (64%)
How to sort lines of text file by comparing the sum of column1, 2 and 3? (64%)
Check Demo of Text file splitter
|adjacent same value previous split by paragraph how to split a csv split a csv file how to split a csv file led csv files non splitting csv file according to column csv file splitter open source splitting file split csv file by value in column split csv file by value csv splitter by value csv splitter by column value csv split by column value|