How to use Substring_by_delimiter in DataStage?

[SujeethP]

Hi friends,

I facing a problem in splitting the string by delimiter.
I need to take substring that should be in between 2 commas(",")

Please help me out

[priyadarshikunal]

Hi friends,

I facing a problem in splitting the string by delimiter.
I need to take substring that should be in between 2 commas(",")

Please help me out

Welcome Aboard,

I think you need to use Field function. Search the forum for details.

[v2rao]

Hi,

you can use index(), or Field() function. Search the functions by string in px development guide.

[sharantheboss]

Hi,

Use the below function Field(col1,delimeter,instance)

In your case Field(col,',',1) will fetch record before comma deleimter
Field(col,',',2) will fetch after comma deleimter
....................... etc

Regards
BOSS

Hi friends,

I facing a problem in splitting the string by delimiter.
I need to take substring that should be in between 2 commas(",")

Please help me out

[chulett]

While Index() may find it, you'll need to use Field() as noted to actually extract it. Easiest way, that is, not the only way of course.