https://www.mturk.com/mturk/welcome ?
:) Scott -- R. Scott Granneman [email protected] ~ www.granneman.com Full list of publications @ http://www.granneman.com/publications My new book: Google Apps Deciphered @ http://www.granneman.com/books "... a lunch hour isn't long enough to get the unimportant things said. The talk that counts is the talk that doesn't matter, and to get that you need time to spare." ---Clive James On Feb 27, 2009, at 6:12 PM, Robert Citek wrote: > > Let's say cell A1 contains the phrase "Hello, world" and you want to > count the number of "o"s, you can enter this formula in cell B1: > > =LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"O","")) > > I find this a bit of a hack, but it works. It gets kind of messy when > you want to count more than one letter. For example, let's say you > have some DNA sequence in A1 and you want to calculate the GC%: > > =(LEN(A1)-LEN(SUBSTITUTE(SUBSTITUTE(UPPER(A1),"G",""),"C","")))/ > LEN(A1) > > Again, it works, but it's rather ugly. It gets worse if I want to > know how many non-GCTA characters there are in a sequence. > > Ruby has a rather elegant way to do this using regular expressions > (perl has a similar way): > > print A1.gsub(/[GCTA]/i,"").length > > Anyone know of a cleaner way to count the number of characters > within OOo Calc? > > Regards, > - Robert > > > --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
