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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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

Hi,

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

Send me love and KUdos

View solution in original post

2 Replies
gjeremy1617088143

Hi,

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

Send me love and KUdos

JM39
Creator
Creator
Author

That works, thank you so much! 🙂