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
Answers were Sorted based on User's Feedback
Answer / rajendhar reddy kuthuru
we can use convert function to remove special characters or replace a string
convert('$%^@"!',"",string)-stage var1
it will replace all special characters with a single space
compactwhitespace(stagevar1)
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / 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 |
Differentiate between hash file and sequential file?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Give an idea of system variables.
What are the benefits of datastage?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
how to remove duplicates in transformer stage by using stage variables?one example?
When we will go for Data elements?
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
Define Data Stage?
how to identifie,is it innerjoin,leftouter join in lookup?
what are the errors,warnings in datastage
Why do you need stage variables?