[libreoffice-users] Re: problem removing duplicate string in calc

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: users+unsubscribe@global.libreoffice.org
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