Brian, Thank you, I will try this. I think it is the answer 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-tp4092500p4092576.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
