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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

First Letter of Address

Hi,
I have an Address field which has lowercase first letter and uppercase first letter mixed.
Ex:
      1234 dashland Dr
     45238 New York Ave
     74583 california St 

Which filter can I apply in tMap that will change the lowercase first letter addresses to Uppercase.
Requested:
     
    1234 Dashland Dr
     45238 New York Ave
     74583 California St 

I tried row1.Address.UpperCase() and StringHandling.UPCASE(row1.Address) but all the two filters did was 
1234 DASHLAND DR
45238 NEW YORK AVE
74583 CALIFORNIA ST
Thanks,
CM
Labels (2)
1 Reply
Anonymous
Not applicable
Author

I would write a specific routine for it. In the first place it is a nice java beginner task - a quick check in Google shows promissing results:
http://stackoverflow.com/questions/1143951/what-is-the-simplest-way-to-convert-a-java-string-from-al...