Solved: PROPER - Qlik Community

Report Inappropriate Content · ‎2010-04-26

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.

e.g

proper(FirstName) as FirstName

therefore a name that is like gAVin returns back as Gavin

I am aware of the upper function

Or · ‎2010-04-26

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.

Or · ‎2010-04-26

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.

Report Inappropriate Content · ‎2011-09-27

How can i capitalize only the first letter of the first word?

PROPER