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
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
What is use Array size in datastage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How do u convert the columns to rows in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Name the different types of Lookups in Datastage?
What is datastage engine?
Triggers,VIEW,Procedures
How many types of sorting methods are available in datastage?
What are the repository tables in datastage?
Demonstrate experience in maintaining quality process standards?
How complex jobs are implemented in datstage to improve performance?
What is apt_config in datastage?
Can you define merge?
How many Key we can define in remove duplicate stage?