find text that match certain string using regex

Question

I would like to find whether the string contains a certain character(s). if it does then output into a file, if it doesn't then output into another file. My input data looks like this:

exchange    security    volume
TO           AAA        193099
TO           AAB        81000
TO           AAH        2310
TO           AAV        1161144
TO           AAVdbh     675000
TO           ABC        98050

So far I have tried this:

for row in data:
    if 'a' in row['security'] then .....

However, I would like to use regex to match the string i.e. if string contains any lower character then ignore. Thank you so much!

Try if re.search(r"[a-z]", row['security']):

Wiktor Stribiżew
– Wiktor Stribiżew

2016-08-25 09:07:02 +00:00
Commented Aug 25, 2016 at 9:07 — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Aug 25, 2016 at 9:07
Or use .isupper() ...

Maroun
– Maroun

2016-08-25 09:07:32 +00:00
Commented Aug 25, 2016 at 9:07 — Maroun
– Maroun, Commented Aug 25, 2016 at 9:07

Moinuddin Quadri · Accepted Answer · 2016-08-25 09:27:14Z

1

You may use filter with lambda function if only upper values are required.

>>> x = 'PrinOnlyUpperCaseLetter'
>>> filter(lambda x: x.isupper(), x)
'POUCL'

If you want both but in different list:

>>> x = 'PrinOnlyUpperCaseLetter'
>>> upper_list, lower_list = [], []
>>> for i in x:
...     if i.isupper(): 
...         upper_list.append(i)
...     else:
...         lower_list.append(i)

edited Aug 25, 2016 at 9:27

answered Aug 25, 2016 at 9:15

Moinuddin Quadri

48.4k13 gold badges101 silver badges137 bronze badges

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

1 Comment

Moinuddin Quadri Over a year ago

Pleasure is all mine :)

K.Olani · Accepted Answer · 2016-08-25 09:18:37Z

0

try this:

for i in row['security']:
   if re.search(r"[a-z]", i):
   #add to file 1

else: #add to file 2

answered Aug 25, 2016 at 9:18

K.Olani

11 bronze badge

Collectives™ on Stack Overflow

find text that match certain string using regex

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related