DSXchange

Hi All,

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

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.

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.

Hi Ray,

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

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

Hi,

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

_____________________________________________________
Sreeni

Hi,

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

______________________________________________________
Sreeni

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 "_"?

craig

It is before "_" .

As Sreeni said,

Field(Column_Name,"_",1)

It will solve the issue...

SO, not substrings but "delimited substrings".

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