How to make first and last letter capital

[Prince_Hyd]

Hi folks

I have a source file like this

name
hyundai
suzuki
ford
honda

i want to make first and last letter capital how can i perform this.


Thanks

[shiva_reddys447]

Hello,

use this derivation in Tx.

upcase(left(DSLink2.name,1)): DSLink2.name[2,len(DSLink2.name)-2]:upcase(right(DSLink2.name,1))


Replace the DSLink2.name with your column name

[ray.wurlod]

Actually you only need to do it once.

[chandra.shekhar@tcs.com]

Actually Ray, this is a problem with the website.
While posting comments, if the net speed is slow then the comment is posted twice(or thrice)

[chulett]

... and then you go back and delete the extra ones. Anyone can do that as long as they haven't been replied to. Me, I can do it anytime.

[chandra.shekhar@tcs.com]

@Craig,
You also posted two times..

[chulett]

You sure?

[Prince_Hyd]

Hi Siva

perfect solution




Thanks