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
- 17021 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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the method of removing duplicates, without the remove duplicate stage?
How many areas for files does datastage have?
How many types of views are there in a datastage director?
Define oconv () and iconv () functions in datastage?
Why do we use link partitioner and link collector in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
how can we create rank using datastage?what is the meaning of rank?
What are the types of containers and how to create them?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the sortmerge collector?
what is use of SDR function?
describe the Steps to confiure a Qlogic switch
Whats difference betweeen operational data stage (ods) and data warehouse?
How to read the length of word in unix?
