topic PROPER in QlikView https://community.qlik.com/t5/QlikView/PROPER/m-p/224667#M77040 <HTML><HEAD></HEAD><BODY><P>Try using the Capitalize() function - this will capitalize the first letter of every word, which is what you'd want for things like names and titles.</P></BODY></HTML> Mon, 26 Apr 2010 15:16:39 GMT Or 2010-04-26T15:16:39Z PROPER https://community.qlik.com/t5/QlikView/PROPER/m-p/224666#M77039 <HTML><HEAD></HEAD><BODY><P>Is there a function that I can use in the loads script that I can us in the load script that will tidy up my data in a field.</P><P>e.g</P><P>proper(FirstName) as FirstName</P><P>therefore a name that is like gAVin returns back as Gavin</P><P>I am aware of the upper function</P><P></P></BODY></HTML> Mon, 26 Apr 2010 15:13:23 GMT https://community.qlik.com/t5/QlikView/PROPER/m-p/224666#M77039 2010-04-26T15:13:23Z PROPER https://community.qlik.com/t5/QlikView/PROPER/m-p/224667#M77040 <HTML><HEAD></HEAD><BODY><P>Try using the Capitalize() function - this will capitalize the first letter of every word, which is what you'd want for things like names and titles.</P></BODY></HTML> Mon, 26 Apr 2010 15:16:39 GMT https://community.qlik.com/t5/QlikView/PROPER/m-p/224667#M77040 Or 2010-04-26T15:16:39Z PROPER https://community.qlik.com/t5/QlikView/PROPER/m-p/224668#M77041 <HTML><HEAD></HEAD><BODY><P> How can i capitalize only the first letter of the first word?</P></BODY></HTML> Tue, 27 Sep 2011 12:56:18 GMT https://community.qlik.com/t5/QlikView/PROPER/m-p/224668#M77041 2011-09-27T12:56:18Z