Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1334.Text file parser -- How to remove lines from file B.csv with first column come from file A.csv?

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


Similar Examples:
How to remove/delete first column for multiple files? (67%)
How to reverse the order of the first column in text file? (66%)
How to remove all lines with duplicate value in column B in CSV file? (64%)
How to rename files to the first and last line of file contents? (62%)
How to batch rename files to the first date found in the files? (61%)
How to merge lines with identical first row in two files? (60%)
How to merge every 3 lines from file A and every 1 line from file B? (59%)
How to copy/remove files to a folder named by first part of filename? (58%)

Check Demo of Text file parser
Keywords:
identical  compare  only one column  comp  pare  first column  import  values  clear  remove lines in file b  remove lines from csv  compare column  column identical  compare file  file compare  remove csv  csv first column  remove lines more