Issue with Named Regular Expression in Python

Question

I am working on a project wherein I need to split the string below into multiple groups. I am using Named Regular expression to split into 3 groups:

InvoiceNumber
Description
InvoiceAmount

671217            John Doe v Monica Geller, et al.            $55.50
                Pertains To: Joey Tribuiani                                                                               
                Firm's File # ABCDEF-123
                Claim No# 1237474

I am using the following regular expression:

search = '(?P<InvoiceNumber>\d+)\s+(?P<Description>.*?)\s+(?P<InvoiceAmount>.*?)\s+'

What exactly in the data is the InvoiceNumber, Description and InvoiceAmount? — The fourth bird
– The fourth bird, Commented Apr 8, 2020 at 13:38
InvoiceNumber:671217, InvoiceAmount:$55.50, Description:<Text in the middle> — Kiran
– Kiran, Commented Apr 8, 2020 at 13:40
Is the description the text before or after the InvoiceNumber? — The fourth bird
– The fourth bird, Commented Apr 8, 2020 at 13:41
Like this? (?P<InvoiceNumber>\d+)\s+.*?(?P<Description>\$\d+(?:\.\d+)?)\s+(?P<InvoiceAmount>.*(?:\r?\n.*)*) regex101.com/r/ly0Zjl/1 — The fourth bird
– The fourth bird, Commented Apr 8, 2020 at 13:59

The fourth bird · Accepted Answer · 2020-04-08 14:48:07Z

1

You could use

(?P<InvoiceNumber>\d+)\s+.*?(?P<InvoiceAmount>\$\d+(?:\.\d+)?)\s+(?P<Description>\S[\S\s]*)

That will match

(?P<InvoiceNumber> Named group InvoiceNumber
- \d+ Match 1+ digits
) Close group
\s+.*? Match 1+ whitespace chars, then any char except a whitespace char non greedy
(?P<InvoiceAmount> Named group InvoiceAmount
- \$\d+(?:\.\d+)? Match the invoice amount with an optional decimal part
) Close group
\s+ Match 1+ whitespace chars
(?P<Description> Named group Description
- \S[\S\s]* Match a non whitespace char so that there at least is a description and all chars that follow
) Close group

Regex demo

edited Apr 8, 2020 at 14:48

answered Apr 8, 2020 at 14:13

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue with Named Regular Expression in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related