Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frnds, my scenario is like i'm having a record
1234"1323£3434%343434^23232!1212$23232
in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance
- 2 Answers
- 17023 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / srinivas
Please use below function.
convert('!@#$%^&*','',string)
No need of the give space in between codes
Only one step to solve this.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What are the stages in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the difference between hashfile and sequential file?
How to perform incremental load in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are stage variables?
Define Merge?
why do u need the IOS upgradation in a FC switch
What is the importance of the exception activity in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are some different alternative commands associated with "dsjob"?
Define orabulk and bcp stages?
How do u convert the columns to rows in datastage?
How a source file is populated?
Describe stream connector?
