Hi,
How to get only the first 10 charectors from the given input column.
Thanks,
Siva.
How to take first 10 charectors from the input column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Tue Apr 26, 2011 8:49 am
- Location: bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard.
Left() is a Function in the String category.
Code: Select all
Left(InLink.TheColumn, 10)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 26
- Joined: Mon Aug 27, 2007 6:27 am
- Location: Des Moines
Re: How to take first 10 charectors from the input column
you can also use DSLink3.name[1,10]
Regards,
Bharath Tipirisetty
Bharath Tipirisetty
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: How to take first 10 charectors from the input column
Incorrect syntax - this one won't work.Sampath wrote:Use Substring [1,10]
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.