Remove all lines except two duplicates ones

UltraEditLover · Nov 18, 2007#12007-11-18T03:35+00:00

Suppose:

The lines in a file are:

0x0011D300
0x0013CE00
0x0015C900
0x0017C400
0x0017C400
0x0019BF00
0x001BBA00
0x001FB000
0x001FB000
0x0021AB00
0x0023A600

After running the macro the result should be: [only duplicates left]

0x0017C400
0x0017C400
0x001FB000
0x001FB000

Thanks. And It only has to check for duplicates, not triplicates.

As always post "fastest possible version" plz.

Could this be modified to something else to achieve the same result?
^(.*\r\n)\1+

pietzcker · Nov 19, 2007#22007-11-19T00:23+00:00

Hm. The following regex should do it (selects a line that is not preceded or followed by the same line), but UE says that it's an invalid regex.

Code: Select all

^(.*)\r\n(?<!\1\r\n\1\r\n)(?!\1)

Perl doesn't mind, so I don't know why UE does. It seems not to like the backreference in the negative lookbehind. Maybe someone has a better idea because I guess a pure regex would fit the bill as the fastest possible solution...

UltraEditLover · Nov 20, 2007#32007-11-20T00:56+00:00

Any help to either pietzker or me?

Mofi · Nov 20, 2007#42007-11-20T13:22+00:00

Using the regular expression Tim has posted at Special Case: Remove Duplicates TOTALLY, not just one following macro should do the job.

It uses the same regular expression used before to delete all duplicates, but instead of deletion it marks the duplicate lines with a # at start of the lines. Then lines not starting with # are deleted and last the # character from start of the remaining lines are deleted. The result is what you want and it is very fast.

InsertMode
ColumnModeOff
HexOff
PerlReOn
Top
Find RegExp "^(.*)\r\n\1\r\n"
Replace All "#\1\r\n#\1\r\n"
Find RegExp "^[^#].*\r\n"
Replace All ""
Find RegExp "^#"
Replace All ""

UltraEditLover · Nov 21, 2007#52007-11-21T02:58+00:00

WORKS!

BUT: The macro continues to run EVEN after finishing. PLEASE help!

Mofi · Nov 21, 2007#62007-11-21T13:12+00:00

The macro must stop after third replace all. Except you run it via Macro - Play Any/Multiple Times and have checked Play macro to End of File. That is wrong. The macro runs 3 replaces all from top of the file. There is no need for an external loop. Run it 1 times without the end of file option.