cancel
Showing results for 
Search instead for 
Did you mean: 

How to split one name (full name) into forename & family name

SwatiAgrawal
Level 5
Hi,
Please suggest what formula/calculation should I put in to split full name into forename & family name.
Eg: I have a data item with name - Swati Agrawal. Then how can I split this so that I get one data item as "Swati" and other data item as "Agrawal". In short, how do I split full name into forename & family name.

Looking forward to your help.
Thanks.

------------------------------
Swati Agrawal
------------------------------
14 REPLIES 14

Hi,

Can you confirm once if you are using the following asset from DX Exchange: Blue Prism PDF Tool Kit

If yes, then can you try to use the below action within it and show me exactly what kind of an output you are getting?

20532.png

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

Hi, 

We tried using this methodology but with no luck, because our PDF has checkboxes, the asset was not providing us the necessary outputs so we switched to the basic stuff of considering it as a text file(able to recognize checkboxes as a key-value pair) and performing data extractions.

------------------------------
Chakkravarthi PR
------------------------------

Hi,

Well you guys can try one approach at this point, keep the original way that you guys are using for identifying the checkboxes but at the same time if this approach is giving you the proper formatted first name and last name then use this piece of code for identifying this section of PDF.

You can employ a mixed strategy of using both the ways to get the desirable output because your current approach of text extraction won't work for separating the first name and last name.

I would suggest you verify the results of this VBO for the section we are concerned with and let me know if that is giving us a formatted first name and last name or not.


Other options can be to try other VBO's for extracting the text from PDF such as the iTextSharp one or by employing a python script to get the data but I would suggest lets first try the above approach and see if we get the formatted text or not.

------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please mark it as the 'Best Answer' so that the others members in the community having similar problem statement can track the answer easily in future

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

Hi, 

If we are going with the first approach, which Adobe version do we need to use( we have Adobe Acrobat Reader DC, not Adobe DC PRO).
The inputs for the PDFtoWord have 3 inputs were in which are aware of the PDF File path and Docx Output Path but what is the Credentials file path, could you please give us a brief with any SS that will be really helpful!.

------------------------------
Chakkravarthi PR
------------------------------

Hi Chakkravarthi,

Per your requirement for splitting text without space, you can achieve it using Regular Expressions. Please refer to the solution below:

  1. Use 'Extract Regex Values' action from Utility - Strings VBO.
  2. The action asks for 3 input parameters : Regex Pattern(Text), Target String (Text) and Named Values (Collection). I've created the respective data items for all the 3 parameters.20549.png
  3. Use this as Regex Pattern : (?<FirstName>[A-Z][a-z]+){1}(?<LastName>[A-Z][a-z]+){1}
  4. Input String is the text you want to split without spaces. I've used my name VikrantSharma in this case.20550.png
  5. For Named Values, create a collection and define it with two text type fields : 'Name' and 'Value'20551.png
  6. And create two initial values as below:20552.png
  7. Assign 'Named Values' collection to the action output and Run the action. You'll have your output with the First name and Last name like below.20553.png
  8.  Now you can extract first name and Last name by either using Filter Collection in default Collection Manipulation VBO or using a loop like below:20554.png
  9. In the Loop , just check if 'Named Values.Name' is First Name. If yes, assign 'Named Values.Value' in 'Yes' path of the decision for First Name and if no, then same expression for 'No' path for Last Name.

Note: Please make sure that the input text is constant, i.e., First name and Last name should start with an Uppercase letter without any spaces and in case there are 3 uppercase letters in your string, only first two Uppercase sets will be considered.

------------------------------
Vikrant Sharma
Senior Solution Designer
Blue Prism
------------------------------
Vikrant Sharma Senior Solution Designer Blue Prism