| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro for detect palindromes and repeats in letters/numbers string
Dear all,
I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GAG 2 AG 3 GG 2 GAG 2 AA 1 AA 1 GG 2 Somebody could help me? Thanks in advance, Luciano |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro for detect palindromes and repeats in letters/numbersstring
On 14 abr, 11:58, Luciano Paulino da Silva
wrote: Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes * * Number * * * * *Repeats * * * * Number QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3 GAG * * * * * * 2 * * * * * * * AG * * * * * * *3 GG * * * * * * *2 * * * * * * * GAG * * * * * * 2 AA * * * * * * *1 * * * * * * * AA * * * * * * *1 * * * * * * * * * * * * * * * * GG * * * * * * *2 Somebody could help me? Thanks in advance, Luciano Correction: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GGAAGG 1 GG 2 GAAG 1 AG 3 GAG 2 GAG 2 GG 2 AA 1 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro for detect palindromes and repeats in letters/numbers string
You have multiple responses at your other threads.
Luciano Paulino da Silva wrote: On 14 abr, 11:58, Luciano Paulino da Silva wrote: Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GAG 2 AG 3 GG 2 GAG 2 AA 1 AA 1 GG 2 Somebody could help me? Thanks in advance, Luciano Correction: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GGAAGG 1 GG 2 GAAG 1 AG 3 GAG 2 GAG 2 GG 2 AA 1 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro for detect palindromes and repeats in letters/numbersstring
Thank you for your attention Dave.
However, to date we have no solution to the problem. Thanks in advance, Luciano On 14 abr, 14:13, Dave Peterson wrote: You have multiple responses at your other threads. Luciano Paulino da Silva wrote: On 14 abr, 11:58, Luciano Paulino da Silva wrote: Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes * * Number * * * * *Repeats * * * * Number QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3 GAG * * * * * * 2 * * * * * * * AG * * * * * * *3 GG * * * * * * *2 * * * * * * * GAG * * * * * * 2 AA * * * * * * *1 * * * * * * * AA * * * * * * *1 * * * * * * * * * * * * * * * * GG * * * * * * *2 Somebody could help me? Thanks in advance, Luciano Correction: QGAGGAAGGAGQ Palindromes * * Number * * * * *Repeats * * * * Number QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3 GGAAGG * * * * *1 * * * * * * * GG * * * * * * *2 GAAG * * * * * *1 * * * * * * * AG * * * * * * *3 GAG * * * * * * 2 * * * * * * * GAG * * * * * * 2 GG * * * * * * *2 AA * * * * * * *1 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro for detect palindromes and repeats in letters/numbers string
By multiposting your question to multiple newsgroups, it just means that your
answers are scattered. I know that lots of people won't take time answering questions that may have been answered in a different forum. I think that it's just a waste of time. Luciano Paulino da Silva wrote: Thank you for your attention Dave. However, to date we have no solution to the problem. Thanks in advance, Luciano On 14 abr, 14:13, Dave Peterson wrote: You have multiple responses at your other threads. Luciano Paulino da Silva wrote: On 14 abr, 11:58, Luciano Paulino da Silva wrote: Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GAG 2 AG 3 GG 2 GAG 2 AA 1 AA 1 GG 2 Somebody could help me? Thanks in advance, Luciano Correction: QGAGGAAGGAGQ Palindromes Number Repeats Number QGAGGAAGGAGQ 1 GA 3 GGAAGG 1 GG 2 GAAG 1 AG 3 GAG 2 GAG 2 GG 2 AA 1 -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro for detect palindromes and repeats in letters/numbersstring
Dear Dave Peterson,
I'm sorry about this. I'm not experient in such newsgroups. Excuse me for this strange procedure. Luciano On 14 abr, 15:34, Dave Peterson wrote: By multiposting your question to multiple newsgroups, it just means that your answers are scattered. *I know that lots of people won't take time answering questions that may have been answered in a different forum. *I think that it's just a waste of time. Luciano Paulino da Silva wrote: Thank you for your attention Dave. However, to date we have no solution to the problem. Thanks in advance, Luciano On 14 abr, 14:13, Dave Peterson wrote: You have multiple responses at your other threads. Luciano Paulino da Silva wrote: On 14 abr, 11:58, Luciano Paulino da Silva wrote: Dear all, I am looking to detect palindromes (sentence or number or other sequence of units that can be read the same way in either direction) and repeats (sequences of letters or numbers which are repeating atleast twice within a string) in some strings containing between 20-5000 letters. Has somebody any idea how could I perform that using an Excel macro? I would like that the string to be evaluated could be on cell "A1" and that the detected palindromes and repeats could be listed bellow A2 and C2, respectively; and that the number of times that they appear in the sentence could be listed bellow cells B2 and D2, respectively, as the following small example: QGAGGAAGGAGQ Palindromes * * Number * * * * *Repeats * * * * Number QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3 GAG * * * * * * 2 * * * * * * * AG * * * * * * *3 GG * * * * * * *2 * * * * * * * GAG * * * * * * 2 AA * * * * * * *1 * * * * * * * AA * * * * * * *1 * * * * * * * * * * * * * * * * GG * * * * * * *2 Somebody could help me? Thanks in advance, Luciano Correction: QGAGGAAGGAGQ Palindromes * * Number * * * * *Repeats * * * * Number QGAGGAAGGAGQ * *1 * * * * * * * GA * * * * * * *3 GGAAGG * * * * *1 * * * * * * * GG * * * * * * *2 GAAG * * * * * *1 * * * * * * * AG * * * * * * *3 GAG * * * * * * 2 * * * * * * * GAG * * * * * * 2 GG * * * * * * *2 AA * * * * * * *1 -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
| How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
| Macro repeats and then stops | Excel Discussion (Misc queries) | |||
| How can I count the number of times a letter repeats in a string? | Excel Worksheet Functions | |||
| how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) | |||
Linear Mode
