ETL and Data Integration tools - Modern ETL software for everyone

Hello

I have a list of doctors which looks like this

D.John Smith
Dr.Peter Monday
Dr. Mark Smith

I want to transform it into

Doctor John Smith
Doctor Peter Monday
Doctor Mark Smith

Any help would be appreciated,
Min Foo

Can you try latest version please

4.2.4.15

LeftPad(S,Length,Char):String, Pads Left part of the string with Character Char
RightDelete(S,Length):String, Deletes Right part of the string
RegularExpression(S,Expression):Boolean, Returns true if string matches expression
EncodeXMLElement(S,ElementName):String, Returns XML Element ElementName="S"
DecodeXMLElement(S,ElementName):String, Returns XML Element Value
EncodeXMLAttribute(S,AttributeName):String, Returns XML Attribute
DecodeXMLAttribute(S,AttributeName):String, Returns XML Attribute Value
EncodeXMLString(S):String,Returns XML String
DecodeXMLString(S):String,Returns XML Element Value

Two new data transformation functions

ReplaceSuffix
ReplacePrefix

Mike