DSXchange

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.

Try ereplace

Thanks u ..It worked

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.

Yes.. I realised my mistake.

Thank you so much for the help.

It solved my problem.