Page 1 of 1
How to take first 10 charectors from the input column
Posted: Tue Apr 26, 2011 11:47 pm
by pgsivareddy
Hi,
How to get only the first 10 charectors from the given input column.
Thanks,
Siva.
Posted: Wed Apr 27, 2011 12:02 am
by ray.wurlod
Welcome aboard.
Left() is a Function in the String category.
Re: How to take first 10 charectors from the input column
Posted: Wed Apr 27, 2011 12:11 am
by tbharathkumar
you can also use DSLink3.name[1,10]
Re: How to take first 10 charectors from the input column
Posted: Wed Apr 27, 2011 1:39 am
by Sampath
Use Substring [1,10]
Re: How to take first 10 charectors from the input column
Posted: Wed Apr 27, 2011 1:54 am
by ray.wurlod
Sampath wrote:Use Substring [1,10]
Incorrect syntax - this one won't work.