Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalmanu
Partner - Creator
Partner - Creator

how to make only few letters as uppercase

Hi All,

i have field with values like Mumbai han 360, Delhi han 430, hyderabad 7680 han, bangalore 6589 han ka.

i need an output like Mumbai HAN 360, Delhi HAN 430, hyderabad 7680 HAN, bangalore 6589 HAN ka in the list box.


can anyone suggest the workaround pls.


Thanks

3 Replies
tomasz_tru
Specialist
Specialist

Replace([field name], 'han', 'HAN')

vishalmanu
Partner - Creator
Partner - Creator
Author

Thanks Tomasz,

I tried the same and it works. Thanks for the response.

tomasz_tru
Specialist
Specialist

Please, mark answer as correct

Tomasz