Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Just a follow up. This worked with one extra step. After creating the 
column as function LOWER(cell content) the resulting column is all 
functions and would not filter. By copying over as text it then filtered 
correctly. (Probably and easier way to do this, but it was quick and 
simple). The extra columns are easily discarded or hidden.
Thanks for the workaround. Actually quite simple. I should have thought 
of it.

On 01/16/2014 08:18 AM, Brian Barker [via Document Foundation Mail 
Archive] wrote:
At 04:36 16/01/2014 -0800, Leon Noname wrote:

I have a column of terms that I pasted from two text files. I have
tried to remove duplicate terms from the list but have the continued
problem of having some of the duplicated terms not removed. One
example is the term "Adrenal hyperplasia" and the other duplicate is
"adrenal hyperplasia".  I have used the standard filter with the
filter being "Col A = Not Empty" and have checked the buttons for
"remove duplicates". I have left unchecked the button for "Case
sensitive" assuming that that would allow for 'Adrenal' to
be the same as 'adrenal'. However, that appears not to be working
and I don't understand why. If anyone could help me understand what
I am doing incorrectly, I would appreciate it.

This does not address your actual query, but a workaround might be to
create a new column with =LOWER(An), =UPPER(An), or
=PROPER(An).  This will create copies of your text items where the
examples you give would become identical.  You could then filter
based on that column instead of the originals.  The extra column
could be hidden or deleted later if you prefer.  Indeed, you might be
happiest using one of these forms of the converted data in place of
the originals.

I trust this helps.


To unsubscribe e-mail to: [hidden email] 
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be 

If you reply to this email, your message will be added to the 
discussion below:

To unsubscribe from problem removing duplicate string in calc, click 

View this message in context:
Sent from the Users mailing list archive at
To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.