Python Regex: multiple regrex causing problem

Question

A basic version of this problem is using an regex to translate something like abc like '%FFddsdE%' into LOWER(abc) like '%ffddsde%'
and the following code works well

import re
text = "abc like '%FFddsdE%'"
print("before: " + text)
text = re.sub('([^ ^\n]+?) ?like ?\'([^ ]+)\'', 
             lambda s: f'LOWER({s.group(1)}) like \'{s.group(2).lower()}\'', 
             text, flags=re.I)
print("after: " + text)


#the output is
#before: abc like '%FFddsdE%'
#after: LOWER(abc) like '%ffddsde%'

However, everything crash down if we want to expand this problem a little bit, to both like and not like

import re

text = "abc not like '%FFddsdE%' and bcd like '%XyZ%'"
print("before: " + text)
text = re.sub('([^ ^\n]+?) ?not like ?\'([^ ]+)\'', 
             lambda s: f'LOWER({s.group(1)}) not like \'{s.group(2).lower()}\'', 
             text, flags=re.I)
text = re.sub('([^ ^\n]+?) ?like ?\'([^ ]+)\'', 
             lambda s: f'LOWER({s.group(1)}) like \'{s.group(2).lower()}\'', 
             text, flags=re.I)
print("after: " + text)

#the output is
#before: abc not like '%FFddsdE%' and bcd like '%XyZ%'
#after: LOWER(abc) LOWER(not) like '%ffddsde%' and LOWER(bcd) like '%xyz%'

It gives LOWER(not) in the output.

I am using python 3 btw. Thanks for any help!

ParsaAlizadeh · Accepted Answer · 2022-07-19 04:51:19Z

3

You could use another group to match like and not like at the same time.

import re
text = "abc not like '%FFddsdE%' and bcd like '%XyZ%'"
print("before: " + text)
text = re.sub('([^ ^\n]+?) ?(like|not like) ?\'([^ ]+)\'',
             lambda s: f'LOWER({s.group(1)}) {s.group(2)} \'{s.group(3).lower()}\'',
             text, flags=re.I)
print("after: " + text)

# before: abc not like '%FFddsdE%' and bcd like '%XyZ%'
# after: LOWER(abc) not like '%ffddsde%' and LOWER(bcd) like '%xyz%'

answered Jul 19, 2022 at 4:51

ParsaAlizadeh

781 silver badge4 bronze badges

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

Collectives™ on Stack Overflow

Python Regex: multiple regrex causing problem

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