Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

225.Text file splitter -- How to split file by columns, and save each column as file a001.txt, a002.txt, ...?

User: editor -- 2008-07-16
Hits: 212
Type: Text file splitter   
Search all Text file splitter examples
Description:
How to split file by columns, and save each column as file a001.txt, a002.txt, ...?
Input Sample:
23.5357132 +35.1897736 AND I
23.4684925 +35.1880264 AND I
23.4012642 +35.1860695 AND I
23.3340359 +35.1838989 AND I
Output Sample:
a01.txt:
23.5357132
23.4684925
23.4012642
23.3340359

a02.txt:
+35.1897736
+35.1880264
+35.1860695
+35.1838989

a03.txt:
AND
AND
AND
AND

a04.txt
I
I
I
I
Answer:
Hint: You need to Download and install "Replace Pioneer" to finish following steps.
1. ctrl-o open source text file
2. ctrl-h open 'Replace' dialog

* set "output file"(at right bottom) to filename with full path like d:\a.txt
* set ">" symbol to "<<< Split by column" to the left of output file.
* click 'settings' page:
set 'Split naming' to:


3. click 'Replace', file will be splited to a_001.txt, a_002.txt, ...
Download Script:  scripts/225.rst.zip

Similar Examples:
How to split files by columns with fixed widths, and save to files with sequence? (55%)
How to batch split files into columns that separated by comma? (52%)
How to split a file by specified number of lines like 10,20,30,20,20,20 ...? (49%)
How to split the dictionary file and use word as filename? (48%)
How to split a file into many files by chapters, and use Chapter names as filenames? (48%)
How to insert two columns into a database file separated by "|"? (47%)
How to split a single line into many lines, keep two words for each line? (45%)
How to sort the files by number, and batch rename them? (43%)

Check Demo of Text file splitter