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
- 16881 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
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
how to sort two columns in single job in datastage.
How to read multiple files using a single datastage job if files have the same metadata?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are some prerequisites for datastage?
What are the components of ascential data stage?
What is difference between join, merge and lookup stage?
Can you filter data in hashed file?
Define repository tables in datastage?
What is the difference between datastage and datastage tx?
Describe the architecture of datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
sed,awk,head
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can you implement SCD2 using join, transformer and funnel stage?
