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
- 16911 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Name the different sorting methods in datastage.
What is the difference between passive stage and active stage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
On which Dimension Table you implemented SCD Type in your Project
What steps should be taken to improve Datastage jobs?
What is process model?
What is datastage engine?
How to reverse the string using SQL?
What is the method of removing duplicates, without the remove duplicate stage?
What are the processing stages?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is ds designer?
How many types of stage?
Notification Activity
