CRLF automatically appended in string concat?

[tnt]

Why does this FN return 2 in immediate window?

?CountOccurrencesOfSubStrInBigStr("asdf,qwer,erty, " & Chr$(13) & Chr$(10) & "drgth,fgsda,wetq",Chr$(13) & Chr$(10))


2


Function CountOccurrencesOfSubStrInBigStr(BigString As String, SubString As String) As Integer
CountOccurrencesOfSubStrInBigStr = Len(BigString) - Len(Replace(BigString, SubString, ""))

End Function

[June7]

BigString is 34 characters, including the two characters for Chr$(13) & Chr$(10)

SubString is 2 characters, the Chr$(13) & Chr$(10)

You replace the 2 characters with empty string, resulting in 32 character string.

34 - 32 = 2

[ssanfu]

Why does this FN return 2 in immediate window?

?CountOccurrencesOfSubStrInBigStr("asdf,qwer,erty, " & Chr$(13) & Chr$(10) & "drgth,fgsda,wetq",Chr$(13) & Chr$(10))
2


Function CountOccurrencesOfSubStrInBigStr(BigString As String, SubString As String) As Integer
CountOccurrencesOfSubStrInBigStr = Len(BigString) - Len(Replace(BigString, SubString, ""))

End Function

Because that is the result of your function.

Chr$(13) = (CR) = carriage return (1 character)
Chr$(10) = (LF) = line feed (1 character)

So if you count the length of "BigString", including the space, CR & LF, you get 34.
Then you replace CR & LF (length of 2) with "" (Nothing, a length of 0). Now the length of "BigString" is 32.
When you subtract the two lengths, 34 - 32, you get 2.

If you want to count the occurrences,look at this site:

www.freevbcode.com

Count the Number of Occurrences of a Character Sequence in a String

http://www.freevbcode.com/ShowCode.a...025&NoBox=True