vba - Editing a string in VB -

vba - Editing a string in VB -

i need username email address removing part after "@" symbol. example,

dim uemail string dim uname string umail = email_tb.text.tostring() 'suppose returns abc.xyz@pqr.com uname = umail (and code) 'this homecoming abc.xyz

using vb can using split method:

dim umail = email_tb.text.tostring() dim uname string = split(umail, "@")(0)

using vb.net utilize substring , indexof methods accomplish this:

dim umail = email_tb.text.tostring() dim uname string = umail.substring(0, umail.indexof("@"))

vba