| User: editor -- 2008-12-26 << 308 310 >> |
| Hits: 654 |
| Type: Text merge |
| Search all Text merge examples |
| Description: |
| How to merge adjacent lines having same value in column one in CSV files? |
| Input Sample: |
aaa,a1,a2,a3
aaa,a4,a5
bbb,b1,b2
bbb,b3,b4,b5
ccc,c1,c2
ccc,c3 |
| Output Sample: |
aaa,a1,a2,a3,a4,a5
bbb,b1,b2,b3,b4,b5
ccc,c1,c2,c3 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
|
1. ctrl-o to open CSV file
2. ctrl-h open "Replace" dialog
Fill in "Search for pattern":
Fill in "Replace with pattern":
3. click "Replace" done!
Note: if 3 or more lines have same value in column 1, you need repeat above steps, untill all of them merged. |
| Download Script: scripts/309.rst.zip |
Screenshot 1: Replace_Window
|
|
Similar Examples: |
How to remove all lines with duplicate value in column B in CSV file? (68%)
How to remove all lines that have duplicate contents in CSV files? (60%)
How to extract all lines that has more than 4 columns from csv file? (60%)
How to merge two text file base on the value of first column and do sort? (57%)
How to search and replace words in specified column in csv file? (52%)
How to extract multiple lines in specified order from many text files? (52%)
How to remove/delete lines of csv file with column C containing 'CCC'? (52%)
How to remove/delete all lines ending by a comma(,) in a text file? (52%)
|
|
Check Demo of Text merge |
| Keywords: |
| merge adjacent lines adjacent lines avi adjacent line adjacent repeat 123 merge text merge merg merge lines same column column merge merge column merge files files merge lines to column value column |