How can I delete duplicate address entries?

[Melissa2006B]

I screwed up an address list in my word processor file. It's a list of addresses that's about 40 pages long and I accidentally pasted some duplicate addresses in there and saved it.

Does Writer have a way that I can identify and delete all complete duplicate addresses, all in one operation?

These addresses consist of name on one line, then address on the next line, then city state & zip on the 3rd line, then phone on the next line.

[/b]

[RonIA]

As you can guess, it appears the answer is probably no.

One thing to consider, did you do a bulk paste operation? Are all the duplicates in the same block?

I guess you have probably already tried most things. A macro could be written, but it would be rather involved.
_________________
Ron from Iowa, USA

[Villeroy]

Blind suggestion without testing, assuming english user interface and assuming you look for duplicate names in every 3rd row:
Copy the entire text
Open a new spreadsheet
Paste to cell A1
Column A should have all the lines
Ctrl+End should jump to last used cell in column A.
B1: =MOD(ROW();3)
copy cell B1 to B2
C1: = 0
C2: =IF($B2=0;COUNTIF($A$1:$A1;$A2);$C1)
How to copy B2:C2 until end of list:
Select cell B2
Shift+rightArrow
Ctrl+C
Ctrl+Shift+End
Ctrl+V
Ctrl+Home (back to single cell A1)
Menu:Data>Filter>Standard
ColumnC = 0
Copy the filtered range
Paste as unformatted text into a new writer document (Ctrl+Shift+V "unformatted")
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org