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
How to make first and last letter capital
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon May 06, 2013 5:59 am
-
- Participant
- Posts: 21
- Joined: Sat Sep 08, 2007 12:04 am
- Location: bangalore
Re: How to make first and last letter capital
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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 35
- Joined: Mon May 06, 2013 5:59 am
Re: How to make first and last letter capital
Hi Siva
perfect solution
Thanks
perfect solution
Thanks