First Letter of Address

Anonymous — Fri, 03 Feb 2017 18:09:25 GMT

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

Re: First Letter of Address

Anonymous — Fri, 03 Feb 2017 20:23:26 GMT

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-all-caps-words-separated

topic Re: First Letter of Address in Talend Studio

First Letter of Address

Re: First Letter of Address