Interested to Buy Any Domain ? << Click Here >> for more details...
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
- 2 Answers
- 6458 Views
- I also Faced
- E-Mail Answers
Answer Posted / trupti
InputField = "abcdefghijklmnopqrs"
step by step we can use transformer functions as,
1. left(InputField,10) ==> OP will be 'abcdefghij'
2. Use above output in
right (abcdefghij,1)= 'J'
The final derivation will be like below,
Convert(right(left(InputField,10),1),'Z',Inputfield)
Output :- abcdefghiZklmnopqrs
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we improve the performance in datastage?
how to export or import the jobs in .ISX file
Can we use target hash file as a lookup ?
What are routines in datastage?
What can we do with datastage director?
How a routine is called in datastage job?
Can you explain engine tier in information server?
What are the processing stages?
What is the difference between datastage and datastage tx?
What are the types of jobs we have in datastage?
What is datastage engine?
What are the areas of application?
What is the difference between in process and inter process?
Name the command line functions to import and export the DS jobs?
what is 'reconsideration error' and how can i respond to this error and how to debug this
