RE: Macro for detect and list palindromes and repeats in letters/numbe

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

There is no need to post this multiple times. If someone can help, they'll
answer the other question.

"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

.

Relevant Pages

  • Numbers of repeats of a string
    ... 20-5000 letters. ... I would like that the string to be evaluated could be ... on cell "A1" and that the detected repeats could be ... that they appear in the sentence could be listed bellow cells B3, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro for detect palindromes and repeats in letters/numbers string
    ... not the total number of repeats. ... Dim FoundRpts() As String ... Function isRpt(strRpt As String, strPar As String, i As Integer) As ... Dim PalCount As Integer ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Query SQL keeps getting erased
    ... Public Sub AdminExport(sPath As String, sQueryName As String, bEmail As ... Dim cnConn As ADODB.Connection ... >> I have several queries that I run multiple times from some VBA code. ... >> the same query multiple times. ...
    (microsoft.public.access.formscoding)
  • Re: Macro for detect palindromes and repeats in letters/numbers string
    ... you are correct that there are other repeats in this string. ... Dim FoundPals() As String ... Dim PalCount As Integer ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Macro for detect palindromes and repeats in letters/numbers string
    ... MS Excel MVP ... Dim FoundRpts() As String ... Repeats = Application.Transpose ... Function isRpt(strRpt As String, strPar As String, i As Integer) As ...
    (microsoft.public.excel.worksheet.functions)