Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

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

User: y8888 -- 2015-05-21          << 1304  1306 >>
Hits: 1155
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