Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1295.Advanced search and replace -- How to delete all lines containing specific word in specific column?

User: Artel -- 2015-04-10          << 1294  1296 >>
Hits: 967
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to automaticaly delete a complete line in a CSV file if a specific colom contains a specific word (SALE)
Input Sample:
1) Colom a / colom b / colom c
2) Colom a / colom b / colom c SALE
3) Colom a / colom b / colom c 
Output Sample:
1) Colom a / colom b / colom c
2) Colom a / colom b / colom c
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
Assume columns are separated by ",", following steps will remove all lines that contain SALE in column 3.
1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'search for pattern' to:

3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to extract all lines containing words in specified file? (74%)
How to extract all lines that contain specific words in a file? (72%)
How to remove lines containing specified words in a text file? (71%)
How to extract lines with specific words in first column? (71%)
How to delete all lines that contain only a word and a blank? (70%)
How to extract lines containg specified words from many files? (68%)
How to findout all lines that contain specified words in multiple files? (68%)
How to extract all lines that contain specified words or phrases? (66%)

Check Demo of Advanced search and replace
Keywords:
complete  specific word  specific  lines containing  comp  delete all lines  separate  automatic  contains  automat  remove columns  remove specific line  remove all lines contains  delete all lines that contain  replace specific word in in a specific column a file  delete columns in text file  delete columns  word search replace delete column