If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Palindromes
Dear all,
Some time ago (http://groups.google.com.br/group/ microsoft.public.excel.worksheet.functions/browse_thread/thread/ 6b068321053a5c90/c6dcff10540e4bc2?q=palindromes+excel+bernie&lnk=ol &) Bernie Deitrick helped me to solve a problem related to palindromes and repeats detection on a string of letters. At present, I need perform some change on that macros in order to detect non-redundant palindromes and repeats. In this way, for the sequence bellow my solution it would be: QGAGAAAAAAAAGGAGQGG 13 Palindromes detected GAG AGA GAAAAAAAAG AA AAA AAAA AAAAA AAAAAA AAAAAAA AAAAAAAA AGGA GG GQG 1 3 Now the solution it would be: QGAGAAAAAAAAGGAGQGG 13 Non-redundant Palindromes detected GAG GAAAAAAAAG GG The big palindromes should be preferred in the occurrences. Thanks in advance, Luciano |
Thread Tools | |
Display Modes | |
|
|