Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1420.Text merge -- How to merge other columns one by one into the first column?

User: kaili Tan -- 2018-08-28          << 1419  1421 >>
Hits: 225
Type: Text merge   
Search all Text merge examples
Description:
How to merge other columns one by one into the first column?
Input Sample:
0 0 0 0
0 0 0 0
0.5* 0 0 0
0 0 0 0
0 0 0 0
0 1.5* 0 0
0 0 2.5* 0
0 0 0 0
0 3.8* 0 0
0 0 0 3.8
0 0 0 1.5
0 0 0 0
Output Sample:
0
0
0.5*
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1.5*
0
0
3.8*
0
0
0
0
0
0
0
0
0
2.5*
0
0
0
0
0
0
0
0
0
0
0
0
0
0
3.8
1.5
0
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' window
* set 'replace with pattern' to:

3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to merge other columns' data base on the value of the first column? (79%)
How to merge the data of second column base on value of first column? (69%)
How to merge two columns of a CSV file? (62%)
How to merge two text file base on the value of first column and do sort? (61%)
How to summrize the number of second column grouping by the first column? (61%)
How to merge more columns into one column in multiple csv files? (60%)
How to merge consecutive lines that have the same first column? (57%)
How to replace the 4th column if the 5th column is 0? (57%)

Check Demo of Text merge
Keywords:
transpose  trans  text merge  merg  merge  mer  first column  columns  ran  the first  merge one file to other  merge by column  merge columns  transpose text  first columns  merge match  column merge  merge column