User: editor -- 2008-11-15 << 294 296 >> |
Hits: 3248 |
Type: Advanced search and replace |
Search all Advanced search and replace examples |
Description: |
How to remove lines of csv file with column C containing 'CCC'? |
Input Sample: |
1,1,BBB,1,1,1,1,CCC 1,1,CCC,1,1,1,1,1 1,1,DDD,1,1,1,1,1 1,1,ACCC,1,1,1,1,1 1,1,AAA,1,1,1,1,1 |
Output Sample: |
1,1,BBB,1,1,1,1,CCC 1,1,DDD,1,1,1,1,1 1,1,AAA,1,1,1,1,1 |
Answer: |
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
1. ctrl-o open source csv file 2. ctrl-h open 'Replace' dialog in 'Replace' page * set 'Replace Unit' to 'Line' * set 'If' to: 3. click 'Replace' button, all lines containing CCC in 3rd column will be removed. Notes:words($match,3,3,',') means the 3rd words in the line. |
Download Script: scripts/295.rst.zip |
Screenshot 1: Replace_Window |
Similar Examples: |
How to remove/delete all lines containing '123456'? (69%) How to delete line with specific columns in specific range? (60%) How to remove/delete first column for multiple files? (60%) How to remove/delete all lines with even line number? (60%) How to remove/delete all lines with three symbol '='? (60%) How to remove/delete all lines with even line number? (60%) How to remove all lines with duplicate value in column B in CSV file? (59%) How to remove/delete following text containing various time? (58%) |
Check Demo of Advanced search and replace |
Keywords: |
3rd lines containing delete lines lines contain delete line containing remove lines csv move lines delete csv remove line containing remove lines in csv containing remove csv remove line in csv file remove all lines containing remove lines containing remove line containing remove words |