a question regarding loop and string manipulation

[yumyu]

Hi,

If i have a Title called " John Smith" and if i press a command button, it changes to "Smith nhoJ"

How do i do that with loop and string manipulation?

Thanks

[Dawoodoz]

use the len(string) function to get the length of the string.
in the first loop you will look at every letter with the mid(string,star t,length) function and see where the space (" ") is.
use the mid again to take the two words and put them in two new strings.
reverse one of them by looping and inserting letters from right to left.
put the two words back together with a space.

[yumyu]

Thanks for your reply.

However i started visual basic not too long ago, and can you please rephrase that in a simplier way.

Thanks

[scripto]

Use the VB function StrReverse()

StrReverse("ABC ") will give you "CBA"

[willakawill]

This will work:

Dim stTitle As String
Dim stFirst As String
Dim stLast As String

stTitle = "John Smith"
stFirst = Left(stTitle, InStr(stTitle, " ") - 1)
stLast = Right(stTitle, Len(stTitle) - InStr(stTitle, " "))
stFirst = StrReverse(stFi rst)
MsgBox stLast & " " & stFirst