Split string with multiple words using regex in python

Question

Suppose I have a expression

exp="\"OLS\".\"ORDER_ITEMS\".\"QUANTITY\"  <50 and  \"OLS\".\"PRODUCTS\".\"PRODUCT_NAME\"  = 'Kingston' or \"OLS\".\"ORDER_ITEMS\".\"QUANTITY\"  <20"

I want to split the expression by and , or so that my result will be

exp=['\"OLS\".\"ORDER_ITEMS\".\"QUANTITY\"  <50','\"OLS\".\"PRODUCTS\".\"PRODUCT_NAME\"  = 'Kingston'','\"OLS\".\"ORDER_ITEMS\".\"QUANTITY\"  <20']

This is what i have tried:

import re
res=re.split('and|or|',exp)

but it will split by each character how can we make it split by word?

Yes and what is your issue exactly? Have you googled 'split string python'? — Julien
– Julien, Commented Nov 20, 2020 at 4:52
@Julien with split string we cannot pass multiple delimiters right? — kavya8
– kavya8, Commented Nov 20, 2020 at 4:55

Mehul Gupta · Accepted Answer · 2020-11-20 05:04:54Z

1

import itertools
exp=itertools.chain(*[y.split('or') for y in exp.split('and')])
exp=[x.strip() for x in list(exp)]

Explanation: 1st split on 'and'. Now try spitting each element obtained on 'or'. This will create list of lists. Using itertools, create a flat list & strip extra spaces from each new element in the flat list

answered Nov 20, 2020 at 5:04

Mehul Gupta

1,9393 gold badges21 silver badges39 bronze badges

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

Comments

Jiří Baum · Accepted Answer · 2020-11-20 05:02:56Z

1

Your regex has three alternatives: "and", "or" or the empty string: and|or|

Omit the trailing | to split just by those two words.

import re
res=re.split('and|or', exp)

Note that this will not work reliably; it'll split on any instance of "and", even when it's in quotes or part of a word. You could make it split only on full words using \b, but that will still split on a product name like 'Black and Decker'. If you need it to be reliable and general, you'll have to parse the string using the full syntax (probably using an off-the-shelf parser, if it's standard SQL or similar).

answered Nov 20, 2020 at 5:02

Jiří Baum

6,9882 gold badges19 silver badges19 bronze badges

Comments

Julien · Accepted Answer · 2020-11-20 05:02:49Z

0

You can do it in 2 steps: [ss for s in exp.split(" and ") for ss in s.split(' or ')]

edited Nov 20, 2020 at 5:02

answered Nov 20, 2020 at 4:58

Julien

15.3k6 gold badges33 silver badges58 bronze badges

1 Comment

kavya8 Over a year ago

but it wont be dynamic I guess if I have a expression with only and exp="\"OLS\".\"ORDER_ITEMS\".\"QUANTITY\" <50 and \"OLS\".\"PRODUCTS\".\"PRODUCT_NAME\" = 'Kingston' ?

Collectives™ on Stack Overflow

Split string with multiple words using regex in python

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related