How to Convert all uppercase letters (after the first letter) in an expression to lowercase.

[profuse]

Hi,

My input data contains all uppercase letters. I would like convert all uppercase letters (after the first letter) in an expression to lowercase. Example: The column lastname is SMITH, I would like to convert it to: Smith.

Does anyone know how to do this?

Thanks

[TRF · Accepted solution]

Hi,
Many ways to do that.
For example:
row1.yourString.substring(0,1).toUpperCase()+row1.yourString.substring(1).toLowerCase()

[profuse]

That Works!!!!
Thank's TRF!!!!!

[profuse]

TRF,

How would you do this for an address column which has the street address and street name in the same column?

example: 2788 CAPITAL MEDICAL BLVD

Would like the result to look like: 2788 Capital Medical Blvd

Thanks

[TRF]

https://stackoverflow.com/questions/1892765/how-to-capitalize-the-first-character-of-each-word-in-a-...

[profuse]

I went to the link and don't see how to code that in the t-Map.

Help!

[TRF]

@profuse as this is not the same quastion, please open a new topic