Datastage Scenario - 1

Scenario:

I have strings MumbaiBangaloreChennai, NaviMumbaiBangaloreChennai, MumbaiPuneBangaloreKolkataChennai, PuneBangaloreKolkataChennai, I need to replace Kolkata with Calcutta if it exists in the string. How it can be achieved? This is in Datastage 8.1

Solution:

If Index(InputCol,"Kolkata",1) =0 Then InputCol Else InputCol [1,Index(InputCol,"Kolkata",1)-1] :"Calcutta":InputCol [Index(InputCol,"Kolkata",1) +7, Index(InputCol, Right(InputCol,1),1)]