How can one use data sort to eliminate duplicate entries

i believe the solution in the blog only does one column.
there are numerous ways of looking for duplications if you're looking for entire rows of duplicates. the easiest is to sort then manually look over the rows. or you can use "if" statements. the number of columns in the row to compare is up to you.

Peter

In the past I have helped people with this.

The method involves exporting the data to a text file and using utilities like sort and uniq in a terminal to eliminate the duplicates before importing the data back into OOo. They were using Calc but it can be done with Writer tables as well.

If you would like me to help you in this way, let me know.

Tony

Peter

In the past I have helped people with this.

The method involves exporting the data to a text file and using utilities like sort and uniq in a terminal to eliminate the duplicates before importing the data back into OOo. They were using Calc but it can be done with Writer tables as well.

If you would like me to help you in this way, let me know.

Tony

Tony,
Thank you for the pointer. I should be able to manage this.

In the past I ran Lotus Symphony under DOS and the sort function
included elimination of duplicates.

Regards

Peter

-----Original Message-----
From: Tony Pursell <email address hidden>
To: peterjdolan <email address hidden>
Sent: Sat, 16 Jul 2011 17:21
Subject: Re: [Question #165029]: How can one use data sort to eliminate
duplicate entries

Your question #165029 on openoffice.org in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029

Tony Pursell proposed the following answer:
Peter

In the past I have helped people with this.

The method involves exporting the data to a text file and using
utilities like sort and uniq in a terminal to eliminate the duplicates
before importing the data back into OOo. They were using Calc but it
can be done with Writer tables as well.

If you would like me to help you in this way, let me know.

Tony

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029/+confirm?answer_id=3

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029

You received this question notification because you asked the question.

Thank you for your suggestion. I had already tried the first.

In the past I ran Lotus Symphony under DOS and its sort function
included the ability to eliminate duplicates. I hoped OOO would
include it but I had not found it!

Regards

Peter

-----Original Message-----
From: marcus aurelius <email address hidden>
To: peterjdolan <email address hidden>
Sent: Sat, 16 Jul 2011 16:56
Subject: Re: [Question #165029]: How can one use data sort to eliminate
duplicate entries

Your question #165029 on openoffice.org in Ubuntu changed:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029

marcus aurelius proposed the following answer:
i believe the solution in the blog only does one column.
there are numerous ways of looking for duplications if you're looking
for entire
rows of duplicates. the easiest is to sort then manually look over the
rows. or
you can use "if" statements. the number of columns in the row to
compare is up
to you.

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029/+confirm?answer_id=1

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029

You received this question notification because you asked the question.

Hi Peter

I'm glad I was able to help. If this answers your question, please go to

https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/165029

and mark the question as Solved.

But if you need any more assistance, please do ask.

Tony

Thanks mycae, that solved my question.