Upper / Lower Case | Sage Report Designer

Question

Hi all 
 One of my colleagues has just asked the following. 
 "Is there any function that converts the first character to the upper case and rests to the lower case? Such as &lsquo;Proper&rsquo; in excel? " 
 Many thanks

Chris Burke · Accepted Answer

Not that I'm aware of, no. Because there's no string split you're a bit limited even in terms of bodging something together from the existing functions. You can do something like this: ToUpper(Substring(SLCustomerAccounts.CustomerAccountName, 0, 1)) + ToLower(Substring(SLCustomerAccounts.CustomerAccountName, 1)) ...but that will only capitalise the very first letter in the entire string, rather than the first letter of each individual word in the string (which is what Excel's PROPER does). If the use case is extremely limited then you could fix the issue in the data model itself. For example if we only needed to do this for CustomerAccountName then you could just modify the data model by deploying an extension that contains something like this: public partial class SLCustomerAccount { [DerivedField("GetNiceName")] public string NiceName { get { return GetNiceName.Compile().Invoke(this); } } [StaticExpandable] public static Expression>GetNiceName { get { return c => ( new System.Globalization.CultureInfo("en-GB", false) .TextInfo.ToTitleCase(c.CustomerAccountName.ToLower()) ); } } } Now the string formatting is being done in the data model itself - so you'd use the NiceName property on the reports that needed it.

Sage 200 UKI

Upper / Lower Case | Sage Report Designer

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING