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
- 17160 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 |
Can you filter data in hashed file?
Define data aggregation?
What is the difference between odbc and drs stage?
specify data stage strength?
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What is ds designer?
What is the difference between Link collector and Funnel Stages?
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
why do we need a datawarehouse when we have databases to store data?
how to write server Routine coding?
how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
Teradata 
