Usage of String as a Delimiter

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
siddharthkaushik
Participant
Posts: 20
Joined: Thu Nov 27, 2003 3:45 am
Location: New Delhi, India

Usage of String as a Delimiter

Post by siddharthkaushik »

Hello All,

I am trying to extract a subsrting based on a delimiter. Now all of you must be thinking that this is easy and why I am asking this question?

The reason is that the delimiter I am supposed to use is a string and not a chracter. All the substring functions in the DS BASIC use a single character as a delimiter rather than a string itself.

The other problem I have is that I cannot write a routine. This is a client requirement. So I have to do this in a Transformer Stage itself.

An example:

The Value String = "ABCDEFGHIJKL"
The Delimiter String = "EFG"
The Resultant String1 = "ABCD"
The Resultant String2 = "HIJKL"

Any insights?

Thanks,
Siddharth
Post Reply