Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a scenario like, I have a field with Upper case date. Let take
Tab1:
Name,
Age,
Salary
Dept
From xyz.xlsx
In field "Name"(ex: TARUN) I have all upper case data and I would like to convert it as "First letter upper and Remaining in lower" (ex: Tarun).
How many ways I can try to convert it into this format.
I have used.
1: CAPITAL function
2. Upper() & Mid()
It will be helpful if there is any other way to convert.
Thanks in advance
Varun K
Hi,
capitalize is enough. If you need string function in qlikview check below thread
Regards
You can use the Capitalize function for that. Capitalize('TARUN') returns 'Tarun'.
Hi,
capitalize is enough. If you need string function in qlikview check below thread
Regards
Hi,
Capitalize command is the right way to fulfill your requirement.