| User: artel -- 2016-01-05 << 1333 1335 >> |
| Hits: 3278 |
| Type: Text file parser |
| Search all Text file parser examples |
| Description: |
| How can I compare (CSV)file A (with one colum) with file B (more then one column) and remove lines in file B which have an identical value in the first column? |
| Input Sample: |
| file A: 1) A 2) C 3) F file B: 1) A, x, y, z 2) B, c, t, s 3) C, d, r, u |
| Output Sample: |
| result: 1) B, c, t, s |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| Assume file A.csv has only one column, and put it in the folder of "d:\test\" 1. ctrl-o open file B.csv 2. ctrl-h open 'replace' dialogue: * set 'replace unit' to 'Line' * set 'if' to: * click 'advanced' tab, set 'run following at the beginning of replace' to: 3. click 'replace', done. 4. ctrl-s save to file. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |