Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

499.Text file splitter -- How to batch split files into columns that separated by comma?

User: editor -- 2010-05-06          << 498  500 >>
Hits: 1627
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