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: 
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...