I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
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
what is repositery?
What are the enhancements made in datastage 7.5 compare with 7.0?
How to convert RGB Value to Hexadecimal values in datastage?
Name the third party tools that can be used in datastage?
What are the important features of datastage?
How many types of hash files are there?
Have you have ever worked in unix environment and why it is useful in datastage?
whom do you report?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
root tree will find which is server job and which is parallel job?
In Datastage, how you can fix the truncated data error?
What is the difference between datastage and datastage tx?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Differentiate between data file and descriptor file?
How a routine is called in datastage job?