I have a value in a drop down that is equals to ‘NA’. Unfortunately, my selector was programmed like this:
+row(3).ToString.Substring(0, 1).ToUpper & row(3).ToString.Substring(1,row(3).ToString.Length - 1).ToLower+
So my guess is the bot is reading the value NA like Na. Can someone help me fix my code? I’m not that good with string manipulation. Thanks!
Yah atlast instead of ToLower mention as ToUpper and try once
Would this affect the other value? I’m afraid once I change something on the selector is that it would no longer work on the others
As per this expression there ToLower atlast that makes why searching as Na
If it is set to ToUpper it will search as NA
My problem is once I change this to the code you gave, what would happen to other values that the bot should proper case? For example is the word APPLE, my bot changes it to Apple. I need a code that would cater the exact value in the file and would do proper case. Is that possible?
Kindly have a view on this thread for propercase
So would I just use the assign activity with a value of: Console.WriteLine(StrConv(title, firstnameStr.ProperCase)) with my variable instead of title?