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

Six Stars

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

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

 


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

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

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

TRF

All Replies
Fifteen Stars TRF
Fifteen Stars

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

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

TRF
Six Stars

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

That Works!!!!
Thank's TRF!!!!!
Highlighted
Six Stars

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

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

 

 

 

 

Fifteen Stars TRF
Fifteen Stars

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

Six Stars

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

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

Help!

Fifteen Stars TRF
Fifteen Stars

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

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


TRF

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now