DSXchange

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

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

Actually you only need to do it once.

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)

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

@Craig,
You also posted two times..

You sure?

Hi Siva

perfect solution




Thanks