Using regular expression for fetching multiple keywords using python 3.4

Question

I am using python 3.4 in windows 7. I have excel sheet in which data is present in every cell. The data is of different kinds .Two examples :- "Qwert A_B_C_1 uiop" and "Qwert A_X_Y_Z uiop"

To sum up i have to extract keywords which are written in CAPS where just after the first word an underscore is present. The extracting should stop once a whitespace is encountered

I have tried something like this but

x =  "QWERT A_B_C_1 UIOP"
se = re.findall("[A-Z]+_[A-Z]+_[A-Z]+_[0-9A-Z]+",x)

But it is not working with different types of keywords.

@Maroun Maroun - what if i dont know as to how many words and underscores are present after A_. How can i read the entire keyword till a whitespace is encountered.?? — Maxxie
– Maxxie, Commented Feb 11, 2015 at 8:47
@vks the expected output is the keyword written in caps starting with A_ — Maxxie
– Maxxie, Commented Feb 11, 2015 at 8:49

vks · Accepted Answer · 2015-02-11 08:45:41Z

1

[A-Z]+(?:_[A-Z]+)*_[A-Z0-9]+

You can use this to capture variable _[A-Z] in between.See demo

import re
p = re.compile(r'[A-Z]+(?:_[A-Z]+)*_[A-Z0-9]+')
test_str = "QWERT A_B_C_1 UIOP\nQwert A_X_Y_Z uiop"

re.findall(p, test_str)

answered Feb 11, 2015 at 8:45

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

Comments

Maxxie · Accepted Answer · 2015-02-11 09:04:16Z

0

I explored more options and came up with

lst = re.findall('\S+_\S+', test_str)

Works as expected.....

answered Feb 11, 2015 at 9:04

Maxxie

3971 gold badge4 silver badges14 bronze badges

1 Comment

vks Over a year ago

This will match !@#!@#_!@#####!@# that's it.Iw wont match A_B_C_D.it will give that as a list of broken elements

Collectives™ on Stack Overflow

Using regular expression for fetching multiple keywords using python 3.4

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related