How to define the " quote character in the routine

rkdatastage · 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 · 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 · Post by **ray.wurlod** » Tue Aug 01, 2006 5:08 am

Backslash

ArndW · 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 · 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.

rkdatastage · 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