How to capture the value between strings that have commas and quotes?
regex:
Active:(?s)(.*)"
string:
"Activity / Stop: 23.07", "Activity / Active: 21.07", "Activity / Backlog: 0.81"
result:
Desired output:
21.07
Asked
Active
Viewed 22 times
0
Luis Henrique
- 701
- 15
- 36
-
Make the regex not greedy: `Active:(?s)(.*?)"` – Toto Aug 12 '20 at 13:00
-
how can I replace `"` ? – Luis Henrique Aug 12 '20 at 13:02
-
I need to use this regex in an SQL query – Luis Henrique Aug 12 '20 at 13:02
-
`Active:(?s)(.*)\",` - can you try this ? You can only refer captured group $1 if you dont want quotes – rootkonda Aug 12 '20 at 13:03
-
The given regex returns `21.07` as expected. If have another question, please, ask a new one. – Toto Aug 12 '20 at 13:04
-
@rootkonda: Why would you escape the quote? – Toto Aug 12 '20 at 13:05
-
why in SQL double quotes are represented as a column – Luis Henrique Aug 12 '20 at 13:06
-
`ERROR: invalid regular expression: quantifier operand invalid` – Luis Henrique Aug 12 '20 at 13:06
-
I prefer to escape the special characters to match as literal instead of remembering which specific characters should be escaped. It may be optional here but I believe that it doesn't cause any harm. – rootkonda Aug 12 '20 at 13:08
-
can you show an example? – Luis Henrique Aug 12 '20 at 13:09
-
@LuisHenrique - I am not clear on whats your next question. I think Toto or me already gave regex. Please paste here on what u tried( I mean the sql part) – rootkonda Aug 12 '20 at 13:10
-
@rootkonda: Quote is not a special character in regex. Escaping it makes the regex harder to read. – Toto Aug 12 '20 at 13:10
-
This resolved `Active: (. *?)" ` Thanks for personal help – Luis Henrique Aug 12 '20 at 13:11
-
@Toto - I agree it make sense especially when the regex is complex. In https://regex101.com/ website we get an error when we try to match " by selecting python option and if we dont escape it – rootkonda Aug 12 '20 at 13:13
-
@rootkonda: You can change the delimiter, for example use `~` instead of `"` – Toto Aug 12 '20 at 13:15
-
ok got it. Thanks @Toto – rootkonda Aug 12 '20 at 13:22