how to make regex in python

Question

How to make a regex for this:

[1,31:14:18] SELECT * FROM T.roll1

Here what i tried r'\[[^)] \s' but it is not able to give me a output like:

(1, 31:14:18 ,SELECT * FROM T.roll1)

How to get this output?

You can use regex same as regex101.com/r/RdPxxw/1 data = re.search(pattern, text, re.IGNORECASE) and after use data.group(1-3) — Ihor Voronin
– Ihor Voronin, Commented Dec 11, 2018 at 12:15
while ppl here start answering the "question" to get a karma, i would tell that the question is unclear! (specially i can't understand, why here mentioned python if OP asked the question about how to make regex?) — Reishin
– Reishin, Commented Dec 11, 2018 at 14:04

Pedro Lobito · Accepted Answer · 2018-12-11 23:20:15Z

1

You can use something like:

import re
s = "[1,31:14:18] SELECT * FROM T.roll1"
r = [x.strip("[") for x in re.split(",|] ", s)]
print(r)

['1', '31:14:18', 'SELECT * FROM T.roll1']

Python Demo

edited Dec 11, 2018 at 23:20

answered Dec 11, 2018 at 14:00

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

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

Comments

LaSul · Accepted Answer · 2018-12-11 13:59:11Z

0

You will need to do three different regex :

import re

test_str = "[1,31:14:18] SELECT * FROM T.roll1"

first_regex = r"\d+"
second_regex = r",(.*)]"
third_regex = r"] (.*)"

first_matches = re.findall(first_regex, test_str, re.MULTILINE)
second_matches = re.findall(second_regex, test_str, re.MULTILINE)
third_matches =  re.findall(third_regex, test_str, re.MULTILINE)

tuple_matches = first_matches[0], second_matches[0], third_matches[0]

print(tuple_matches)

# Output
# ('1', '31:14:18', 'SELECT * FROM T.roll1')

answered Dec 11, 2018 at 13:59

LaSul

2,4412 gold badges23 silver badges39 bronze badges

Collectives™ on Stack Overflow

how to make regex in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related