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.
Trim " character
Moderators: chulett, rschirm, roy
Re: Trim " character
Try ereplace
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Premium Member
- Posts: 238
- Joined: Fri Jul 25, 2008 8:55 am