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
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
Describe the architecture of datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the difference types of stages?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the difference between datastage and datastage tx?
How to reverse the string using unix?
Why we use surrogate key?
How the ipc stage work?
What is the difference between hashfile and sequential file?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
What all are the different way to run a job?
What is the purpose of pivot stage and types of containers in datastage
Differentiate between operational datastage (ods) and data warehouse?
Does datastage support slowly changing dimensions ?
What are the types of containers and how to create them?