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
- 17161 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does datastage support slowly changing dimensions ?
How do you register plug-ins?
How you can fix the truncated data error in datastage?
In Datastage, how you can fix the truncated data error?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How a source file is populated?
How many types of hash files are there?
What are the different kinds of views available in a datastage director?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
How can we improve the performance in datastage?
Explain usage analysis in datastage?
How to read the length of word in unix?
What is the difference between in process and inter process?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
