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
- 16951 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the job parameters?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
how many types of remove the duplicate records?
what is the definitions for Datawarehose and Datamart?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000
how to call sequential generator in datastage?
What are the functionalities of link collector?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
What are constraints and derivations?
Teradata 
