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
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 |
Explain how a source file is populated?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
how can u connect the client system directly at any time?
Which type of joins Merge stage can support?
How do you remove duplicate values in datastage?
How many number of reject links merge stage can have?
how to implement scd2 in datastage 7.5 with lookup stage
I want capture UnMatched records from Primary source and secondary source in JOIN stage?
can we use sequential file as a lookup
convert yyyy mm dd to dd mm yyyy?
What are the stages in datastage?
Wat is pre-load in Hashed file