Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

672.Replace text in multiple files -- How to delete all lines with column B greater than 90 in multiple csv files?

User: editor -- 2010-12-07          << 671  673 >>
Hits: 375
Type: Replace text in multiple files   
Search all Replace text in multiple files examples
Description:
How to delete all lines with column B greater than 90 in multiple csv files?
Input Sample:
A1,25,C1,D1,E1
A2,95,C2,D2,E2
A3,100,C3,D3,E3
A4,62,C4,D4,E4
Output Sample:
A1,25,C1,D1,E1
A4,62,C4,D4,E4
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. If you replace single file, ctrl-o open csv file
2. ctrl-h open replace window(for single or multiple files)
* set 'replace unit' to 'Line'
* set 'search for pattern' to:

* set 'If=>' to:

3. For single file, click "Replace".
4. For multiple files, click "Batch..." open "Batch Runner"
(1) drag multiple csv files from Windows to "Batch Runner" window.
(2) click "Batch Replace", done!

Screenshot 1:  Replace_Window


Similar Examples:
How to extract all lines with more than 30 characters from multiple files? (68%)
How to add filename as a new column for multiple csv/txt files? (66%)
How to delete the second column in multiple text files? (65%)
How to merge more columns into one column in multiple csv files? (64%)
How to exchange column 2 and column 3 in multiple csv files? (64%)
How to remove/delete first column for multiple files? (64%)
How to extract all lines that contain "abc" from multiple files? (63%)
How to extract all numbers that are greater than 60 in a text file? (63%)

Check Demo of Replace text in multiple files
Keywords:
greater  var  delete all lines  csv  single  how to delete  delete  delet  dele  del  delete lines from csv file  delete lines from csv  delete column from multiple csv  delete lines in csv  csv column delete  delete column csv  delete text lines from multiple files  delete column in multiple files