Trim " character

myukassign · Post by **myukassign** » Fri Jul 25, 2008 9:15 am

Hi ,

I have a small issue. I would like to remove " from a string using trim or any other function availabe in Datastage. Can anyone help me.

E.g. If my argument string is like this Arg1= " Arun"Jose ".

The output I want to see is "Arun Jose", I dont want the " come in between.

I tried to use Trim function like this

Trim(Arq1, """, "A"). But it is giving me error. Can anybody tell wht is the correct to way to specify this in Trim function. OR is there any better function to uise in this case.

sud · Post by **sud** » Fri Jul 25, 2008 9:20 am

Try ereplace

myukassign · Post by **myukassign** » Fri Jul 25, 2008 9:51 am

Thanks u ..It worked

chulett · Post by **chulett** » Fri Jul 25, 2008 10:01 am

EReplace or Convert will do it, but the Trim should work as well. Your problem is you used double-quotes to enclose a double-quote. Put single quotes around it.

myukassign · Post by **myukassign** » Fri Jul 25, 2008 10:31 pm

Yes.. I realised my mistake.

Thank you so much for the help.

It solved my problem.

DSXchange

Trim " character

Trim " character

Re: Trim " character