Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 at least 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.programming
|
|||
|
|||
Macro for detect palindromes and repeats in letters/numbers string
You have a response at one of your other threads.
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 at least 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for detect palindromes and repeats in letters/numbers string | Excel Worksheet Functions | |||
Numbers of repeats of a string | Excel Worksheet Functions | |||
Macro for detect palindromes and repeats in letters/numbers string | New Users to Excel | |||
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric? | Excel Worksheet Functions | |||
Splitting string into letters and numbers | Excel Programming |