Here is a quick and dirty way
Drop the list into calc in column A
In column B put a formula that is =IF(A1=A2;"dup";"") and copy this down
for the 32,000 rows
Then select column B, edit | copy
Go edit | paste special and deselect formulas. Click OK
Then sort the sheet by column B
remove all the rows that have "dup" in column B
select column A and copy and paste it wherever you want it
no more duplicates
Neil
Girard Aquino wrote:
i have around 32000+ words that are paragraph separated (each word on
another line/paragraph). there are duplicate words which i would like to
get rid of. how can i go about this in writer?
this is actually two different word list files in writer. one is around
14000 words, the other 18000. i tried to use the compare document tool,
but i could not isolate the 4000 word difference between the two, so i
combined them to form the 32000 list.
i'm running 2.4 and 3.0 on xp media center.
_________________________________________________________________
Easily edit your photos like a pro with Photo Gallery.
http://get.live.com/photogallery/overview
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
