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
How to use Substring_by_delimiter in DataStage?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: How to use Substring_by_delimiter in DataStage?
Welcome Aboard,SujeethP wrote: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
I think you need to use Field function. Search the forum for details.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
Re: How to use Substring_by_delimiter in DataStage?
Hi,
you can use index(), or Field() function. Search the functions by string in px development guide.
you can use index(), or Field() function. Search the functions by string in px development guide.
thanks!
Rao
Rao
-
- Participant
- Posts: 14
- Joined: Mon Mar 23, 2009 12:57 am
- Location: INDIA
Re: How to use Substring_by_delimiter in DataStage?
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
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
SujeethP wrote: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
DS Info