It’s almost the same, you just have to change to use the CONCAT() function instead of the + operator : UPDATE tb_Company SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), SUBSTRING(CompanyIndustry, 2)); This would turn hello to Hello, wOrLd to WOrLd, BLABLA to BLABLA, etc. If you want to upper-case the first letter and lower-case the other, you … Read more
TextInfo.ToTitleCase() capitalizes the first character in each token of a string. If there is no need to maintain Acronym Uppercasing, then you should include ToLower(). string s = “JOHN DOE”; s = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(s.ToLower()); // Produces “John Doe” If CurrentCulture is unavailable, use: string s = “JOHN DOE”; s = new System.Globalization.CultureInfo(“en-US”, false).TextInfo.ToTitleCase(s.ToLower()); See the MSDN … Read more
use this capitalize filter var app = angular.module(‘app’, []); app.controller(‘Ctrl’, function ($scope) { $scope.msg = ‘hello, world.’; }); app.filter(‘capitalize’, function() { return function(input) { return (angular.isString(input) && input.length > 0) ? input.charAt(0).toUpperCase() + input.substr(1).toLowerCase() : input; } }); <script src=”https://ajax.googleapis.com/ajax/libs/angularjs/1.2.23/angular.min.js”></script> <div ng-app=”app”> <div ng-controller=”Ctrl”> <p><b>My Text:</b> {{msg | capitalize}}</p> </div> </div>
Since dart version 2.6, dart supports extensions: extension StringExtension on String { String capitalize() { return “${this[0].toUpperCase()}${this.substring(1).toLowerCase()}”; } } So you can just call your extension like this: import “string_extension.dart”; var someCapitalizedString = “someString”.capitalize();
Only because no one else has mentioned it: >>> ‘bob’.title() ‘Bob’ >>> ‘sandy’.title() ‘Sandy’ >>> ‘1bob’.title() ‘1Bob’ >>> ‘1sandy’.title() ‘1Sandy’ However, this would also give >>> ‘1bob sandy’.title() ‘1Bob Sandy’ >>> ‘1JoeBob’.title() ‘1Joebob’ i.e. it doesn’t just capitalize the first alphabetic character. But then .capitalize() has the same issue, at least in that ‘joe Bob’.capitalize() … Read more
String str = “java”; String cap = str.substring(0, 1).toUpperCase() + str.substring(1); // cap = “Java” With your example: public static void main(String[] args) throws IOException { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); // Actually use the Reader String name = br.readLine(); // Don’t mistake String object with a Character object String s1 = name.substring(0, 1).toUpperCase(); … Read more
The .title() method of a string (either ASCII or Unicode is fine) does this: >>> “hello world”.title() ‘Hello World’ >>> u”hello world”.title() u’Hello World’ However, look out for strings with embedded apostrophes, as noted in the docs. The algorithm uses a simple language-independent definition of a word as groups of consecutive letters. The definition works … Read more