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!
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.
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.
VbStrConv represents the vb conversion type, and you can replace “brad” with a variable