split queries with regex

Question

#i am using regex to split this but i am getting wrong results.

import re

queries ="""
INSERT ignore into persons VALUES (15,'Tom D.', 'Erilchsen', 
'Skagen 21', 'Erlangen');
select * from persons;
"""

regex = "[;!]+?"
y = re.split(regex ,queries)
print(y)
print(len(y))
print(y[0])

output:

["\nINSERT ignore into persons VALUES (15,'Tom D.', 'Erilchsen', \n'Skagen 21', 'Erlangen')", '\nselect * from persons', '\n']
3

You didn't explain the expected result. Please share it. Is the issue the `\n` ? — azro, Sep 10 '22 at 17:02
use a _slice_ or a _split_ or provide a criteria for the matching — cards, Sep 10 '22 at 18:50
Why dont you just merge `quieries` into one line then run your regex? Even using `queries.replace("\n", "")` — How about nope, Sep 10 '22 at 21:07
no, the issue is the extra element in the list. i have two queries but i am getting one extra element in the list. — asheer ali, Sep 11 '22 at 09:46

score 0 · Accepted Answer · answered Sep 10 '22 at 21:44

You don't actually need a regex for this:

queries ="""
INSERT ignore into persons VALUES (15,'Tom D.', 'Erilchsen', 
'Skagen 21', 'Erlangen');
select * from persons;
"""

y = list(filter(None, queries.replace("\n", "").split(";")))
print(y)
print(len(y))
print(y[0])

split queries with regex

1 Answers1