| User: maadi -- 2013-12-05 << 1152 1154 >> |
| Hits: 2136 |
| Type: Text file splitter |
| Search all Text file splitter examples |
| Description: |
| I have a text file that includes a very large column of numbers. It is a single column that contains 500,000 numbers. I want to break that column into 10 columns each containing 50,000 rows and write that into a new text file. Thank you |
| Input Sample: |
| 1 2 3 . . . 500000 |
| Output Sample: |
| 1 500001 . . . 450001 2 500002 450002 3 . . . . . . . . . 50000 100000 . . . 500,000 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open text file 2. ctrl-h open 'replace' dialogue * set 'replace with pattern' to: 3. click 'replace', done. 4. ctrl-s save to file. Note: you can change 50000 to other values in case you need different number of rows. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to remove the text from line start to the first ":" in each line? (56%) How to extract the 7th column from text files with 8 columns? (55%) How to limit a text file to less than 40 chars each line? (54%) How to delete the 4th column from text files with 8 columns? (53%) How to add a column which is the summary of column 3,4 and 6 in text file? (52%) How to extract the text between first comma and second comma in each line? (51%) How to make math calculation on columns and generate a new column of result? (50%) How to merge other columns' data base on the value of the first column? (50%) |
Check Demo of Text file splitter |
| Keywords: |
| transpose 500 include break trans write different number splitter text file splitter contains break text file into columns split break split a text file into columns split file into columns text file split into columns split text file into columns write column text file splitter columns |