Four Stars

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
1 REPLY
Seventeen Stars

Re: First Letter of Address

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