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
DJRH
Premium Member
Posts: 23 Joined: Fri Jul 07, 2006 9:03 am
Location: Mississauga
Post
by DJRH » Mon Sep 20, 2010 3:18 pm
string ="TestString1 ^^^ TestString2"
MyString = Field(string, "^^^" ,2)
Call DSLogInfo(" The string value is : " : MyString , "JobControl")
Does not fetch the second string.
With single "^" as delimeter it works fine and fetches the " TestString2" but does not work with "^^^". I need to use 3 carets (^^^) as delimeter thus if anybody can help me with this.
anbu
Premium Member
Posts: 596 Joined: Sat Feb 18, 2006 2:25 am
Location: india
Post
by anbu » Mon Sep 20, 2010 3:43 pm
Delimiter should be single character in Field function.
Use EReplace function to convert ^^^ to ^
You are the creator of your destiny - Swami Vivekananda
arunkumarmm
Participant
Posts: 246 Joined: Mon Jun 30, 2008 3:22 am
Location: New York
Contact:
Post
by arunkumarmm » Mon Sep 20, 2010 3:51 pm
Yes, delimiter in Field should only be one character. Or you can simply replace ^^^ with @FM and use @FM as your delimiter
Arun
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Sep 20, 2010 5:17 pm
Not just "should be" but can
only be a single character.
-craig
"You can never have too many knives" -- Logan Nine Fingers
DJRH
Premium Member
Posts: 23 Joined: Fri Jul 07, 2006 9:03 am
Location: Mississauga
Post
by DJRH » Tue Sep 21, 2010 6:26 am
chulett wrote: Not just "should be" but can
only be a single character.
Thanks a lot everyone for your input. I appreciate your quick response.
DJRH
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Tue Sep 21, 2010 6:51 am
So... resolved?
-craig
"You can never have too many knives" -- Logan Nine Fingers
DJRH
Premium Member
Posts: 23 Joined: Fri Jul 07, 2006 9:03 am
Location: Mississauga
Post
by DJRH » Tue Sep 21, 2010 6:59 am
chulett wrote: So... resolved?
Yes, I will consider this as resolved as we do not have any option other then using eReplace or use different delimeter type.
Thanks once again for everyone's input.
DJRH