Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1092.Advanced search and replace -- How to change all lines to columns in a text?

User: shan feng -- 2013-07-02          << 1091  1093 >>
Hits: 1109
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 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%)
How to change letters in Column1 and Column4 to upper case? (59%)

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