String Manipulation ( to flip names in textbox)

[jenbug]

I have text box to enter a name such as Carol Smith

then you click the display new name button and it will write the name as Smith, Carol

I dont if know if that char = 32 is even possible? I thought that was ascii code for a blank space? I am so confused and have worked on this for a couple hours ( i am obviously new to vb.net so dont laugh please, I am not evn sure how to post my code in here) I missed 2 weeks of class b/c of eye surgery and I am so lost!

Any help would be greately appreiciated!

Thanks

Dim strName, strFirstName, strLastName, strNewName As String

[jenbug]

Dim mychar As Char = "32"
strName = Me.NameTextbox.Text
strLastName = strName.Substring(Val(char))
strFirstName = strName.Substring(0, Val(char))

Me.NewNameLabel.Text = strLastName & "," & " " & strFirstName

this is just one of the many ways I have tired this

[taxes]

Hi,

Use the InStr function to find the location of the space.

Dim intLocation As Integer
        Dim intLength As Integer
        Dim strNameReverse As String
        intLength = strName.Length
        intLocation = InStr(strName, " ")
        strNameReverse = Microsoft.VisualBasic.Right(strname, intLength - intLocation) & ", " & Microsoft.VisualBasic.Left(strname, intLocation - 1)

Edited at 00:48 on 04/30/2004 after checking.

[alextyx]

Dear Jenbug, if I understood well, this could be a more general way to solve your problem, expecially useful for names composed by 3, or more, words:

Dim str As String = "Carol Anderson J. Smith"
 
        Dim parts() As String = str.Split(Char.Parse(" "))
        str = ""
        Dim i As Int16 = parts.Length - 1
        Do While i >= 0
            str = str & parts(i)
            If i >= 1 Then
                str = str & ", "
            End If
            i -= 1
        Loop
 
        Debug.WriteLine(str)

In Output window you will read:
Smith, J., Anderson, Carol

[taxes]

Hi Jenbug,

"In Output window you will read:
Smith, J., Anderson, Carol"

Why on Earth would he want to do that?????

For multiple names use

Dim intLocation As Integer
        Dim intLength As Integer
        Dim strNameReverse(10) As String
        Dim strReverse As String
        Dim strName As String = "James Michael Smith"
        Dim intCount As Integer = 0
        Dim intCount1 As Integer = 0
        Do While strName.Length > 1
 
            intLength = strName.Length
            intLocation = InStr(strName, " ")
            If intLocation = 0 Then
                strNameReverse(intCount) = strName
                Exit Do
            End If
            strNameReverse(intCount) = Microsoft.VisualBasic.Left(strName, intLocation - 1)
            strName = Microsoft.VisualBasic.Right(strName, intLength - intLocation)
            intCount = intCount + 1
        Loop
        strReverse = strNameReverse(intCount) & ","
        For intCount1 = 0 To intCount - 1
            strReverse = strReverse & " " & strNameReverse(intCount1)
        Next

strReverse will now show

"Smith, James Michael"

[alextyx]

Ehm, ehm,...I premitted:"if I understood well"
Really, perhaps that way to write names is an english habit, we don't use it. I thought our friends Jenbug needed to obtain a particular format to export/import in other application, or....I don't know!
Anyway I tried to adapt my code:

Dim parts() As String = str.Split(Char.Parse(" "))
        str = ""
        Dim i As Int16 = parts.Length - 1
        Do While i >= 0
            str = str & parts(i)
            If i = parts.Length - 1 Then
                str = str & ", "
            Else
                str = str & " "
            End If
            i -= 1
        Loop
        Debug.WriteLine(str.TrimEnd)

and now you can read:
Smith, J. Anderson Carol

Anyway your code is surely good, too. This is a little more compact. I had to write this for a friend and so I had time to squeeze my brain on the problem. I'm a beginner. I'm sure you are a better programmer than me (really think so!) and I'm sure that in 95% of situations your code should be better of mine, too. But in this particular application, I prefer mine. Then Jenbug will decide...! Good job.

[taxes]

Hi alextyx,

Full names are usually presented in Western languages (not only English) in two ways:

1. In forenames, surname order (which is easier on the eye but renders sorting more difficult)


2. Surname first then forenames in natural order. (This enables automatic sorting in the more frequently required manner).

I have assumed that this is what Jenbug requires.

You can still use your approach of the string.split but you will need to hold the results of the split in a manner from which the surname can be isolated.

[jenbug]

Thanks so much for your help! I appreicate all of your responses and with some (ok LOTS) of trial and error I finally got it ... I hope that someday I know as much about code as all of you. Seems like there is always several ways to code each problem.
Thanks again

Jen

[alextyx]

Ok Taxes. What I have never seen, in our burocratic country (Italy), is the use "Surname", "FirstName" or "Surname", "SecondName" "FirstName".
I've never seen to put a comma among them, in ANY position! But I'm not sure if it's used in some particular situation.
Good programming, to you and to JenBug!

[taxes]

Hi,

"What I have never seen, in our burocratic country (Italy), is the use "Surname", "FirstName" "


How on Earth do you list names in your telephone directories???

[alextyx]

My God! My English is really poor !
What I want to explain is that we don't use comma (",") but only blank spaces to separate surname from name.

Example of your way:

Smith, K. John

Example of our way:

Smith K. John

The only difference is in use of comma.
That's why I didn't catch exactly what Jenbug needed!
Bye taxes, have a nice day

[taxes]

Hi alextyx,

Your English is much better than my Italian

The reason why a comma is used is to indicate the end of the surname. This is necessary where there is a double surname, e.g

Full name is John Michael Smith Jones. If the surname is Smith Jones then is is shown

Smith Jones, John Michael.

whereas if it was shown

Smith Jones John Michael, you would not know if the surname was Smith or Smith Jones.

[alextyx]

It's true, Taxes. I understand the reason. We don't use, but I have to admit that it could be useful. Normally we are able to understand what is the surname, anyway, but some cases could be ambiguos!Bye