https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88008#M38638 What is the best way to extract first name & last name? Full name was like 'Last, First Mid' or 'Last, First'. I was using Trim, InStr, Replace...types of functions which is creating issues. For some transactions, it's fetching the correct data. For some, it's fetching only a part of the required name and for some, it's throwing an error that the . I'm looking for a standard way to extract this data. Wed, 07 Mar 2018 10:23:00 GMT SudheerReddy 2018-03-07T10:23:00Z https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88008#M38638 What is the best way to extract first name & last name? Full name was like 'Last, First Mid' or 'Last, First'. I was using Trim, InStr, Replace...types of functions which is creating issues. For some transactions, it's fetching the correct data. For some, it's fetching only a part of the required name and for some, it's throwing an error that the . I'm looking for a standard way to extract this data. Wed, 07 Mar 2018 10:23:00 GMT https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88008#M38638 SudheerReddy 2018-03-07T10:23:00Z https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88009#M38639 You probably will be able to do it with decision and calculation stages - you just need to experiment a lot and test your logic against as many different examples of the text as possible.  The errors you are getting simply suggest your InStr logic for finding commas or spaces needs improving. Off the top of my head - getting the last name should be easy thanks to that comma.  Something like: Trim(Left([NameText],InStr([NameText,"","")-1)) For the first names you need some kind of logic that extracts the positions of all the spaces (the gaps between first names - there could be more than just two) - and they loop through extracting each name. Wed, 07 Mar 2018 16:58:00 GMT https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88009#M38639 Denis__Dennehy 2018-03-07T16:58:00Z https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88010#M38640 Thanks for the reply Denis. I'll try this. Wed, 07 Mar 2018 22:01:00 GMT https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88010#M38640 SudheerReddy 2018-03-07T22:01:00Z https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88011#M38641 thanks Tue, 13 Mar 2018 13:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Extract-first-name-last-name/m-p/88011#M38641 Anonymous 2018-03-13T13:10:00Z