String manipulations

[tytus2005]

I wonder if there is any way to manipulate strings in VBA just like it can be done in C/C++. I mean - is there any way to do something like accessing single letter with []? For example is there any way to check for example third letter in a word in C/C++ way (word[2])?

 

[GlennUK]

Use the MID function like this:

Mid(mystring, 3, 1)



Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[lucrahouse]

I have used the following:

MyString = "some where over the rainbow?"

MyAnswer = InStr(1, MyString, "w")

MyAnswer will equal 6

If I was looking for the letter "q" then MyAnswer will = 0

Hope this helps.

 

[rmikesmith]

If your code is string manipulation intensive it may be faster to convert the strings to a byte array and back. Otherwise, Glenn & lucrahouse's suggestions are the simplest. VBA allows the following direct assignments, with regard to byte arrays:

Dim abytTemp() as Byte
Dim strInput as String
Dim strOutput as string

   strInput = "Somewhere over the rainbow"
   abytTemp = strInput
   ...
   strOutput = abytTemp

Regards,
Mike