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
- 17028 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
How to convert RGB Value to Hexadecimal values in datastage?
What are sequencers?
What is a merge in datastage?
Can you explain players in datastage?
How do you import and export data into datastage?
What is the precedence of stage variables,derivations, and constraints?
What is ibm datastage flow designer?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is aggtorec restructure operator?
What is the differentiate between data file and descriptor file?
What is oci?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
How to read multiple files using a single datastage job if files have the same metadata?
What is usage analysis in datastage?
