How to delete duplicate numbers in notepad ++?

Question

I've been trying to do use the ^(.*?)$\s+?^(?=.*^\1$) but it doesnt work.

I have this scenario:

9993990487 - 9993990487
9993990553 - 9993990553
9993990554 - 9993990559
9993990570 - 9993990570
9993990593 - 9993990596
9993990594 - 9993990594

And I would want to delete those that are "duplicate" and spect the following:

9993990487
9993990553
9993990554 - 9993990559
9993990570
9993990593 - 9993990596
9993990594

I would really appreciate some help since its 20k+ numbers I have to filter. Or maybe another program, but it's the only one I have available in this PC.

Thanks,

Josue

`^(\d+)\h+-\h+\1$` and replace with `$1` – Wiktor Stribiżew Feb 24 '20 at 22:20 — Wiktor Stribiżew, Feb 24 '20 at 22:20
take a look at this post, maybe it will help:
– SOlangsam Feb 24 '20 at 22:22 — SOlangsam, Feb 24 '20 at 22:22

Wiktor Stribiżew · Accepted Answer · 2020-02-24T23:17:33.757

2

You may use

^(\d+)\h+-\h+\1$

Replace with $1.

See the regex demo.

Details

^ - start of a line
(\d+) - Group 1: one or more digits
\h+-\h+ - a - char enclosed with 1+ horizontal whitespaces
\1 - an inline backreference to Group 1 value
$ - end of a line.

The replacement is a $1 placeholder that replaces the match with the Group 1 value.

Demo and settings:

edited Feb 24 '20 at 23:17

answered Feb 24 '20 at 22:23

Wiktor Stribiżew

607,720
39
448
563

It worked fine in the regex demo, but when I tried in this PC it doesn't work. Thanks for the help Wiktor! – Josue Feb 24 '20 at 22:55
@Josue It works alright in Notepad++, too. I added a **proof**. – Wiktor Stribiżew Feb 24 '20 at 23:17

How to delete duplicate numbers in notepad ++?

1 Answers1