User: artel -- 2016-01-05 << 1333 1335 >> |
Hits: 2955 |
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 |