Extract substring

DSRajesh · Post by **DSRajesh** » Tue Aug 07, 2012 9:42 pm

Hi All,

How to extract substring "settle" in the string XXX_Settle" using datastage functions?

jwiles · Post by **jwiles** » Tue Aug 07, 2012 9:50 pm

Search here (Information Server 8.7 Information Center) for "extracting substrings". The functions are largely valid for DS 7x as well. You can also search the DS 7x documentation included with the product.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 07, 2012 11:41 pm

Do you want the rightmost six characters every time? Do you want everything after the underscore character irrespective of how long? There are many possibilities. The link James provided will allow you to research them all, but a more specific question would allow us to help more cogently.

DSRajesh · Post by **DSRajesh** » Wed Aug 08, 2012 2:59 am

Hi Ray,

I need to pick the all the character before '-' in the string.

Ravi.K · Post by **Ravi.K** » Wed Aug 08, 2012 3:34 am

Apply Index function it will give position of the "-" then apply substring function.

ssreeni3 · Post by **ssreeni3** » Wed Aug 08, 2012 3:40 am

Hi,

Single "_" or might chance multiple"_" s occurs in the string?

_____________________________________________________
Sreeni

ssreeni3 · Post by **ssreeni3** » Wed Aug 08, 2012 3:44 am

Hi,

Use the below function to get all the characters before the first "_" in a column
Field(Column_Name,"_",1)
It might work.

______________________________________________________
Sreeni

chulett · Post by **chulett** » Wed Aug 08, 2012 6:57 am

DSRajesh wrote:I need to pick the all the character before '-' in the string.

Which doesn't match your example and the original question. Did you actually mean after the "_"?

DSRajesh · Post by **DSRajesh** » Wed Aug 08, 2012 8:15 am

craig

It is before "_" .

Ravi.K · Post by **Ravi.K** » Wed Aug 08, 2012 8:34 am

As Sreeni said,

Field(Column_Name,"_",1)

It will solve the issue...

ray.wurlod · Post by **ray.wurlod** » Wed Aug 08, 2012 3:08 pm

SO, not substrings but "delimited substrings".

An equivalent to the Field() function would be square brackets notation.

Code: Select all

Column_Name["_",1,1]