kingaaronm Posted October 5, 2009 Share Posted October 5, 2009 I have a query that will return names of people. The names are all in upper case in the database but I would like to make them be proper cased... Is there a way to actually do this? Link to comment Share on other sites More sharing options...
mdahlman Posted October 5, 2009 Share Posted October 5, 2009 kingaaronm, Your database probably has string functions you can use to achieve this. Java does not have functions built-in to do this easily. The Apache Commons Lang project has functions to make this easy. For example it has "capitalize" and "capitalizeFully". You'll find discussions of commons lang in other threads. Regards,Matt Link to comment Share on other sites More sharing options...
harinderrakkar Posted October 6, 2009 Share Posted October 6, 2009 U can do this with the help of Database functions...like upper,lower,initcap etc. hope this will work. Link to comment Share on other sites More sharing options...
xavier.bonislawski Posted October 19, 2017 Share Posted October 19, 2017 HelloThe topic is old but it may be usefull...Use the "PROPER" text buil-in function in jaspersoft studioRegards Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now