How to replace a string in DataStage

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;

If Index(UpCase(Ln_L40_Cust_Det.SERVICE),'FUNCTIONAL',1) > 0 Then

Left(Ln_L40_Cust_Det.SERVICE,Index(UpCase(Ln_L40_Cust_Det.SERVICE),'Functional',1)-1):'Technical':Right(Ln_L40_Cust_Det.SERVICE,Len(Ln_L40_Cust_Det.SERVICE)-Len(Left(Ln_L40_Cust_Det.SERVICE,Index(UpCase(Ln_L40_Cust_Det.SERVICE),'Functional',1)-1):'Functional'))

Else
Ln_L40_Cust_Det.SERVICE


Link Name:Ln_L40_Cust_Det

Please let me know if you have any queries about the logic.