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. Ciao Leon
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. > > Brian > > > -- > To unsubscribe e-mail to: [hidden email] > </user/SendEmail.jtp?type=node&node=4092511&i=0> > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > > > ------------------------------------------------------------------------ > If you reply to this email, your message will be added to the > discussion below: > http://nabble.documentfoundation.org/problem-removing-duplicate-string-in-calc-tp4092500p4092511.html > > > To unsubscribe from problem removing duplicate string in calc, click > here > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4092500&code=bGVvbjI0NEBjb21jYXN0Lm5ldHw0MDkyNTAwfDIwNjE5MDMzNzk=>. > NAML > <http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > > -- View this message in context: http://nabble.documentfoundation.org/problem-removing-duplicate-string-in-calc-tp4092500p4092582.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
