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          << 224  226 >>
Hits: 450
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" on windows platform 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 
* 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

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Settings_Window


Similar Examples:
How to split files by columns with fixed widths, and save to files with sequence? (55%)
How to sort lines of text file by comparing the sum of column1, 2 and 3? (53%)
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 copy a file 100 times with different name from 1.txt to 100.txt? (48%)
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 split a text file into multiple files and take the date as filename? (47%)

Check Demo of Text file splitter
Keywords:
a001  split file by columns  split file by column  split naming  naming  path  symbol  sym  text file splitter  splitter  split text file by columns  split by columns  text file splitter by columns  text file splitter columns  split file columns  split text file columns  split columns text file  split text file to columns