| User: editor -- 2008-11-15 << 294 296 >> |
| Hits: 663 |
| 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 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%) How to remove/delete all blank lines in a text file? (56%) |
Check Demo of Advanced search and replace |
| Keywords: |
| 3rd lines containing delete lines lines contain csv delete line containing remove lines move lines delete remove csv remove line in csv file remove all lines containing remove words remove column column remove lines to column replace column csv |