I have seen several web sites which are explaining most of the things on DataStage, but I have not seen easiest way to replace a string by using DataStage functionality without using Ereplace Function.
Field Name: SERVICE
Requirement: If the service description contains the word "Functional", then replace the word with "Technical".
Source Service Desc: My Functional Service for you...!!!
Expected Target Service Desc: My Technical Service for you...!!!
Logic to get the output as per the specified requirement;
