Extract Firstname and Last name from the string after specific text format

Help Studio
, , , ,
1

Hi ,

I am trying to extract Fname and Lname from a string which follows specific text.
This is the sample text

“Begäran om behörighet för p123abc Firstname Lastname - Andra behörighet (random text)”.

I just want first name and last name in two different variables.

Any help would be much appreciated. Thank you .

2

HI @benjamin.9052

Can you share the Exact output for the query.

Here is extracted data for the last Name

Use Assign Activity

LHS → Create an variable
RHS → Sysytem.Text.RegularExpression.Regex.Match("InputString","(?<=Lastname\s-\s)(\S.+)").Tostring

image
image849×194 11.9 KB

Regards
Gokul

3

Here is extracted data for the first Name @benjamin.9052

Use Assign Activity

LHS → Create an variable
RHS → Sysytem.Text.RegularExpression.Regex.Match("InputString",".*(?=Firstname)").Tostring

image
image856×240 10.9 KB

Regards
Gokul

4

Hi ,

sorry if i caused a confused a confusion, I am just looking for the string “Firstname” and “lastname” in that statement as my outputs , as that would vary for each case . Just as a sample i replaced the real names with “Firstname” and “lastname” which follows the string P+3 numbers+3chars(P123abc) from the sample.

5

HI @benjamin.9052

Can you just share the
First Name = ?
Last name = ?

From the below input

Regards
Gokul

6

“Begäran om behörighet för p123abc Benjamin Kattula - Andra behörighet (random text)”.

So here First name =benjamin , Lastname = Kattula which are the expected outputs from this string

Thank you

7

working with regex we do require a reliable pattern. have a look here for the start

grafik
grafik802×284 13.5 KB

8

Hi @benjamin.9052

Use Assign Activity

LHS → Create an variable
RHS → Sysytem.Text.RegularExpression.Regex.Match("InputString","(?<=[a-z]\d{3}\D{3}\s)(\S+)").Tostring

image
image850×225 11 KB

Use Assign Activity

LHS → Create an variable
RHS → Sysytem.Text.RegularExpression.Regex.Match("InputString","(?<=[a-z]\d{3}\D{3}\s)(\S+)\K\s(\S+)").Tostring

image
image1601×377 37.2 KB

Regards
Gokul

1 Like
9

Thank you , let me try this

10

we would recommend to cross check your scenario on other names which can be expected:

A simple name like Rob Robot is easy to split on space into firstname Last. But as long we have to expect any names we cannot handle like this. Examples

Double Names:
Ann Mary Johnson - Johnson Last name
Charlotte van Felde, Gregory van den Haag - van Felde, van den Haag Last names

and so on.

Is it reliable to expect only simple firstname lastname pairs?

11

Thank you , I will keep this in mind . if there are complex names , i will try to change my input parameter and change with a different string .

12

Thanks Gokul , I had issue with ‘/K’ but I found this helpful.

13

Great @benjamin.9052

Happy Automation

Regards
Gokul

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.