| User: shan feng -- 2013-07-02 << 1091 1093 >> |
| Hits: 3315 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to change all line to column in a text? |
| Input Sample: |
| a1 a2 a3 a4 b1 b2 b3 b4 c1 c2 c3 c4 |
| Output Sample: |
| a1 b1 c1 a2 b2 c2 a3 b3 c3 a4 b4 c4 |
| 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. Note: assume all columns are seperated by space. If you just want to put everything into one column, like: a1 a2 a3 a4 b1 b2 b3 b4 ... you can follow the same procedure, except that setting "replace unit" to "line" in step 2. |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to shuffle all the lines in a text file? (65%) How to extract all lines with numbers from many text files? (64%) How to replace all duplicate lines with some text? (63%) How to join every 3 lines into 3 columns of csv file? (62%) How to remove all lines but the second line from bottom? (61%) How to change the direction of all sentences in a text file? (61%) How to delete all the lines without ceramics in text file? (60%) How to change all negative numbers to the format of (number)? (60%) |
Check Demo of Advanced search and replace |
| Keywords: |
| transpose seperate except trans lines to column same columns setting space every except search text same column search by column change a line to a column change line to column lines in a column text columns text to columns |