Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
RSS: Replace Pioneer Examples
1422.Text merge -- How to merge remaining columns into the first column?
User:
kaili Tan -- 2018-10-07
<< 1421
1423 >>
Hits:
2275
Type:
Text merge
Search all
Text merge
examples
Description:
how to merge remaining columns into the first column
Input Sample:
1, 4, 100, 123, 100
2, 8, 110, 456, 200
3, 9, 111, 789, 300
4, , 211, 987, 400
5, , 811, , 500
Output Sample:
1
2
3
4
5
4
8
9
100
110
111
211
811
123
456
789
987
100
200
300
400
500
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:
transpose(replace(transpose($match, ','), '\s+', ' '))
3. click 'replace', done.
Screenshot 1: Replace_Window
Similar Examples:
How to merge other columns one by one into the first column?
(78%)
How to merge the data of second column base on value of first column?
(68%)
How to merge other columns' data base on the value of the first column?
(67%)
How to merge more columns into one column in multiple csv files?
(63%)
How to merge many files into one file?
(62%)
How to divide each column by the first number?
(62%)
How to summrize the number of second column grouping by the first column?
(62%)
How to merge two columns of a CSV file?
(61%)
Check Demo of
Text merge
Keywords:
transpose
trans
text merge
merg
merge
mer
first column
columns
ran
the first
merge columns
transpose text
first columns
merge match
column merge
merge column
merge replace
merge text