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
rkdatastage
Participant
Posts: 107 Joined: Wed Sep 29, 2004 10:15 am
Post
by rkdatastage » Tue Aug 01, 2006 3:16 am
Hi All
Can any one give me a suggestion to resolve this problem.
here is my routine
Function getstr(Arg1)
SubString = Trim(Arg1, ""","A")
Ans=SubString
Return(Ans)
what i am trying to do is to eliminate the " [ double Quote Character ] in the given string.
Ex : "London" -> London
How to define the " quote character in the routine
Thanks in Advance
RK
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Aug 01, 2006 4:13 am
You can use single quotes, double quotes and the ampersand quote character in the same job.
Code: Select all
DoubleQuote = '"'
SubString = TRIM(Arg1,DoubleQuote,"A")
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 01, 2006 5:08 am
Backslash
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Aug 01, 2006 6:14 am
Achhh, thanks for correcting me, I typed too fast and didn't check what I'd written. I won't go back and correct the post, but the line should read
"You can use single quotes, double quotes and the backslash quote character in the same job"
jgibby
Participant
Posts: 42 Joined: Thu Dec 16, 2004 8:48 am
Post
by jgibby » Wed Aug 02, 2006 11:14 am
Suggestion to Moderators: Since we are seeing so many topics in here that don't relate to Datastage TX, how about considering renaming this forum to Websphere Transformation Extender? This is what IBM is starting to call TX.
"Artificial intelligience is no match for natural stupidity."
rkdatastage
Participant
Posts: 107 Joined: Wed Sep 29, 2004 10:15 am
Post
by rkdatastage » Thu Aug 03, 2006 12:00 am
Hi All
I Apologize for wrongly posted in TX Forum
and
Thanks for your valuable Response
RK