Getting name in an email address

[redanime94 (Red)]

I got this code to retrieve the name within the email address:
StrConv(Split(emailAddress, “@”.ToCharArray)(0).Replace(“.”, " "), VbStrConv.ProperCase)

However when I try to run it I am getting this error:
Write Line: No data is available for encoding 1252. For information on defining a custom encoding, see the documentation for the Encoding.RegisterProvider method.

When I run this using VB, Windows-Legacy it runs well. How do I make this work using VB, Windows setting?

Thanks.

[arjunshenoy]

Hi @redanime94

You can use a RegEx to extract the data and then do the necessary string manipulations:

^[^@]+

Use the following expression:

userName = System.Text.RegularExpressions.Regex.Matches(emailAddress,"^[^@]+").Vaue

Then you can replace the . with a space.

Hope this helps,
Best Regards.

[redanime94 (Red)]

Thanks for that. I took a cue from your suggestion and used the following:

System.Text.RegularExpressions.Regex.Matches(emailAddress,“^[1]+”).ToString.Replace(“.”, " ")

alternately, I also had this:
Split(emailAddress, “@”.ToArray)(0).Replace(“.”, " ")

---

1. ^@ ↩︎

[Jithesh_R]

@redanime94 ,
Please try this one

Split("User.Name@Gmail.com","@")(0).Replace("."," ")

Regards,

[redanime94 (Red)]

Yup had the same thing above. Thanks for that.

I just need to make the name now in proper case.

[redanime94 (Red)]

Got it!

System.Globalization.CultureInfo.CurrentCulture.TextInfo.ToTitleCase(NameFromEmail)
where
NameFromEmail is the below