Replace Pioneer Home All Examples Free Download

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

User: Artel -- 2015-04-10 << 1294 1296 >>

Hits: 3067

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