| User: editor -- 2010-05-06 << 498 500 >> |
| Hits: 604 |
| 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 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%) How to add italic tags for all lines that started with hash #? (53%) How to batch download jpg files that listed in an excel file in order? (53%) |
Check Demo of Text file splitter |
| Keywords: |
| math generate multiple files batch split fil batch split split naming naming rules text file splitter splitter split files split the input file by columns batch file that split columns batch split comma csv splitter columns batch split file delimiter split file into columns batch split comma separated batch split csv file columns |