Regex pattern for pyhton

Help Something Else
1

can someone help me with regex, I have been trying to get the data from a pdf file and I cant seem to get the right regex for it.

Screenshot 2023-08-04 153937
Screenshot 2023-08-04 1539371381×511 68 KB

I just want to get the names as highlighted and ignore *,A,B,C,ABC and all the rest to the right with long white space. Initially I got this regex:

[A-ZÑ ]+,\s\w*[A-ZÑ]\s\w*A-ZÑ.

2

Hi.
How many spaces or other white characters are between names (BERNANDO DABALOS) and column on the right (BALATGUTI)?
It will be helpfull information, which we need to separate words from the column on the right

3

Hey @Jhun_III_Daganzo ,
Try the below regex it might help you out

([A-Za-z]+, [A-Za-z]+\s[A-Za-z]+\.[A-Za-z]+)|([A-Za-z]+, [A-Za-z]+)

Below is the output screenshot

image
image707×215 14.6 KB

Hope it helps you out

4

Hi @Jhun_III_Daganzo

Provide the Input data as text then it will help us to extract the data easily.

1 Like
5
6

Thanks for the help but it still does not capture when using multiline.

Here-> regex101: build, test, and debug regex

7

sample data here →

8

@Jhun_III_Daganzo ,
Can you once try with below regex
\b\w+, \w+(?: \w+)?(?: \w+)?(?: \w+)\b

9

Its almost capturing the data but it still captures the data from the right with long spaces. Is there a way to not capture the data after a long space?

10

$ symbol will capture till end of the string

try with the below regex
\b\w+, \w+(?: \w+)?(?: \w+)?(?: \w+)?(?=\s|$)\b

11

Hi @Jhun_III_Daganzo

Check the below regular expression

[A-Z]+\,\s+[A-Z]+\s+[A-Z]+\s{1}[A-Z]+|[A-Z]+\,\s+[A-Z]+\s+[A-Z]+|[A-Z]+\,\s+[A-Z]+.*\s+[A-Z]+\s{1}[A-Z]+

image
image1434×758 113 KB

Hope it helps!!

12

Thank you for your help. I really appreciate it.

13

Thank you @Jhun_III_Daganzo

Hope you find the solution. Make mark it as solution to close the loop.

Happy Automation!!

14

Thank you for your help.

1 Like
15

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