Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JM39
Creator
Creator

UPCASE and TRIM together

Hello everyone. I'm wondering if there's a way to use UPCASE & TRIM together. For example, I currently have in my tMap

StringHandling.TRIM(row1.Supplier_Name)

But I also want the output of this column to be in upper case too. Is it possible to do that?

Thank you!

Labels (2)
1 Solution

Accepted Solutions
gjeremy1617088143
Master
Master

Hi,

StringHandling.UPCASE(StringHandling.TRIM(row1.Supplier_Name))

Send me love and KUdos

View solution in original post

2 Replies
gjeremy1617088143
Master
Master

Hi,

StringHandling.UPCASE(StringHandling.TRIM(row1.Supplier_Name))

Send me love and KUdos

JM39
Creator
Creator
Author

That works, thank you so much! 🙂