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: 2263
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 delete all columns with more than 8 words in text file? (67%)
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%)

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