| User: shanfeng -- 2014-12-09 << 1270 1272 >> |
| Hits: 3017 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to merge and average unique lines with same character in the first column found in from different files? |
| Input Sample: |
| File A: 59750 1.2 1.4 1.8 59752 1.2 1.6 1.4 59753 1.2 1.8 1.2 File B: 59750 1.2 1.6 1.8 59751 1.2 1.4 1.6 59752 1.2 1.6 1.8 |
| Output Sample: |
| 59750 1.2 1.5 1.8 59751 1.2 1.4 1.6 59752 1.2 1.6 1.6 59753 1.2 1.8 1.2 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| For multiple file, you should join them into a single file at first, then you can do following steps: 1. ctrl-o open the file(already joined together) 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Line' click 'advanced' tab * set 'insert begin text' to: * set 'run following at the beginning of replace' to: * set 'run following for each matched unit' to: 3. click 'replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |