Capitalize first letter of a string

Hi, I have a column of string names (ex: brad), that I am extracting from an excel column. Anyway, when I am printing this variable how do I make it that the name has the first letter capitalized? I tried looking at the VB.net forums but couldn’t find anything.

Thanks!

5 Likes

Hi!

You want Title/Proper Case. Check the info here on converting the string to title/proper case:
https://support.microsoft.com/en-us/help/312897/how-to-convert-string-to-lowercase-uppercase-or-title-proper-case-by-u

Hope that helps. Regards.

1 Like

So would I just use the assign activity with a value of: Console.WriteLine(StrConv(title, firstnameStr.ProperCase)) with my variable instead of title?

Almost.
image

VbStrConv represents the vb conversion type, and you can replace “brad” with a variable

17 Likes