Regex to grab a string present between (comma or whitespace) and fixed string

Question

I want a string between (comma or whitespace) and a string.

The code I am using is

re.findall('[,]?[\s]*(.*?)[.]calc', string)

The output I get on running this

String 1 = "Select ID, Deliveryid.calc"
Result = Deliveryid
String 2 = "Select Deliveryid.calc"
Result = Select Deliveryid.calc

Now For string two I just want the Deliveryid and not the hole. Basically I want the string before ".calc" and "whitespace or comma". It can be anyone or both in the case of comma and whitespace

There can be a newline or tab also. Basically any type of whitespace along with the comma. Both can be present or anyone.

FYI - I want all the matching strings in the string. there can be one or many

Do you mean [ .]([^ .]*)\.calc / [\s.]([^\s.]*)\.calc (demo)? Or simply [\s.](\w+)\.calc? — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Nov 10, 2020 at 10:56
The problem is with what space or comma to start matching from or what (.*?) can match. Please clarify these points. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Nov 10, 2020 at 11:06
Well, yes, I used a . instead of a , in the above comment. Still, the question remains. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Nov 10, 2020 at 11:22
Please still edit to show a good example of an input string with multiple occurrences, and the expected output for that. — tripleee
– tripleee, Commented Nov 10, 2020 at 12:27

Wiktor Stribiżew · Accepted Answer · 2020-11-13 11:50:45Z

1

You can use

[\s,]([^\s,]*)\.calc

See the regex demo. Details:

[\s,] - a whitespace or comma
([^\s,]*) - Group 1: any zero or more chars other than whitespace and comma
\.calc - a .calc string.

See the Python demo:

import re
text = 'Select ID, Deliveryid.calc Select ID, Deliveryid.calc Select ID, Deliveryid.calc\nSelect Deliveryid.calc Select Deliveryid.calc'
print( re.findall(r'[\s,]([^\s,]*)\.calc', text) )
# => ['Deliveryid', 'Deliveryid', 'Deliveryid', 'Deliveryid', 'Deliveryid']

answered Nov 13, 2020 at 11:50

Wiktor Stribiżew

631k41 gold badges502 silver badges633 bronze badges

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

Comments

Vikrant Korde · Accepted Answer · 2020-11-10 11:15:39Z

0

Modified the regex slightly

import re
String1 = "Select ID, Deliveryid.calc"
String2 = "Select Deliveryid.calc"
m1 = re.search('[, ]([^, ]*?)[.]calc', String2)
print ('->' + m1.group(0) + '<-')
print ('->' + m1.group(1) + '<-')

I think you should get value of group(1).

answered Nov 10, 2020 at 11:15

Vikrant Korde

4297 silver badges14 bronze badges

2 Comments

BrownBatman Over a year ago

Why findall is not working as I am getting \t\n while using findall but when using match it gives the correct answer. And how to get the list and not the object while using match?

BrownBatman Over a year ago

And there can be multiple matching strings in that. So how get the list for all.

Heenu Pathak · Accepted Answer · 2020-11-10 12:26:33Z

0

You have to use greedy regex operators. try this:

^[^.]+

It will match everything before the dot Note: that when using greedy operators, you'll match everything before the last .(dot) instead of the first. As per your string it matches everything before the .calc

If you want only a word before .(dot) then "Wiktor Stribiżew" has already helped you out for that. His expression works for me similar way.

Happy Learning !!

answered Nov 10, 2020 at 12:26

Heenu Pathak

1446 bronze badges

Collectives™ on Stack Overflow

Regex to grab a string present between (comma or whitespace) and fixed string

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related