Replace Pioneer Home All Examples Free Download

1305.Advanced search and replace -- How to delete rows with same column as previous line?

User: y8888 -- 2015-05-21 << 1304 1306 >>

Hits: 2602

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

Delete rows with the same content of the line, leaving only one line.

Input Sample:

B1 DeepPink
B1 LightPink
B1 Indigo
B3 Plum
B3 DarkMagenta
B5 Blue
B5 Navy
B5 AliceBlue
B5 Navy
B5 SkyBlue

Output Sample:

B1 DeepPink
B3 Plum
B5 Blue

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'if =>' to:

3. click 'replace', done
4. ctrl-s save to file

Screenshot 1: Replace_Window

Similar Examples:

How to remove (2) and add (1) at the same location in previous line? (64%)
How to delete last column in a csv file? (63%)
How to delete all lines whose first word appeared in previous line? (62%)
How to delete rows in csv based on criteria of some column? (59%)
How to delete line with specific columns in specific range? (59%)
How to delete the same field in each line? (58%)
How to delete all columns with more than 8 words in text file? (57%)
How to remove/delete following text containing various time? (57%)

Check Demo of Advanced search and replace

Keywords:

delete rows avi previous same column same content how to delete delete delet dele delete the same line only one column replace with previous line delete column column delete delete words search same file search replace file content