https://community.blueprism.com/t5/Product-Forum/Utility-Strings/m-p/84278#M35440 I have a text data item that stores a person name "John Doe" or can be of the format "John M Doe". However, I want to extract just the last name "Doe". I have tried Business Object "Utility String" - "Split Text". However this BO gives me the output as a collection and not as a text data item which I am looking for. Suggestion welcome. Tue, 27 Sep 2016 22:25:00 GMT john_shiels 2016-09-27T22:25:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Strings/m-p/84278#M35440 I have a text data item that stores a person name "John Doe" or can be of the format "John M Doe". However, I want to extract just the last name "Doe". I have tried Business Object "Utility String" - "Split Text". However this BO gives me the output as a collection and not as a text data item which I am looking for. Suggestion welcome. Tue, 27 Sep 2016 22:25:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Strings/m-p/84278#M35440 john_shiels 2016-09-27T22:25:00Z https://community.blueprism.com/t5/Product-Forum/Utility-Strings/m-p/84279#M35441 UPDATE: There is no InStrRev function (yet) in the calculation stage.... If you don't want to go into RegEx, and you want to get the last name... Make a new object (e,g. named: Get last name) In the object make a code stage, and put the following code in: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 'IN: Full_Name (Text) 'OUT: Last_Name (Text) if Full_Name.IndexOf("" "") > 0 then Last_Name = Full_Name.Substring(Full_Name.LastIndexOf("" "") +1) end if ******************************************************************** The above worked a treat. Thank you Wed, 28 Sep 2016 21:28:00 GMT https://community.blueprism.com/t5/Product-Forum/Utility-Strings/m-p/84279#M35441 john_shiels 2016-09-28T21:28:00Z