User: editor -- 2010-05-06 << 498 500 >> |
Hits: 5126 |
Type: Text file splitter |
Search all Text file splitter examples |
Description: |
How to batch split files into columns that separated by comma? There are many csv files, each of them is separated by comma in each line, how to split each csv file into columns, and generate multiple files with rules in following example: |
Input Sample: |
file1.csv file2.csv file3.csv ... |
Output Sample: |
file1_column1.txt file1_column2.txt file1_column3.txt ... file2_column1.txt file2_column2.txt file2_column3.txt ... file3_column1.txt file3_column2.txt file3_column3.txt |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. ctrl-h open "Replace" window 2. click 'Settings' page: * Change the "split naming" entry to: * Set "Word Delimiter/input delimiter" to "Other", and input a comma(,) in the following entry. * Change the ">" at the right hand bottom of the page to "<<< Split by column" (between out page and output file) 3. click 'Batch...' button to open Batch Runner window 4. drag all csv files to the "Batch Runner" window. 5. click 'Batch Replace', all files will be generated at the folder where the csv files located. |
Screenshot 1: Replace_Settings_Window |
Similar Examples: |
How to batch rename files by changing specified part separated by dash? (62%) How to extract specified columns from a large pipe separated csv file? (59%) How to batch rename html files to the content that between a pair of h2 tags? (57%) How to insert two columns into a database file separated by "|"? (56%) How to split a file into two parts according to the content of line? (55%) How to split files by columns with fixed widths, and save to files with sequence? (55%) How to batch rename files in different folders and move them to a common folder? (54%) How to change all numbers in a text file to the comma separated numbers? (54%) |
Check Demo of Text file splitter |
Keywords: |
math split naming generate multiple files naming bottom batch split files batch split batch split fil batch split file csv files split the input file by columns batch file that split columns batch split comma batch split comma separated batch split csv file columns batch file split comma batch csv splitter split csv columns into multiple files |