The best answers to the question “RegEx: Grabbing values between quotation marks” in the category Dev.
I have a value like this:
"Foo Bar" "Another Value" something else
What regex will return the values enclosed in the quotation marks (e.g.
Foo Bar and
In general, the following regular expression fragment is what you are looking for:
This uses the non-greedy *? operator to capture everything up to but not including the next double quote. Then, you use a language-specific mechanism to extract the matched text.
In Python, you could do:
>>> import re >>> string = '"Foo Bar" "Another Value"' >>> print re.findall(r'"(.*?)"', string) ['Foo Bar', 'Another Value']
I’ve been using the following with great success:
It supports nested quotes as well.
For those who want a deeper explanation of how this works, here’s an explanation from user ephemient:
([""'])match a quote;
((?=(\\?))\2.)if backslash exists, gobble it, and whether or not that happens, match a character;
*?match many times (non-greedily, as to not eat the closing quote);
\1match the same quote that was use for opening.
Lets see two efficient ways that deal with escaped quotes. These patterns are not designed to be concise nor aesthetic, but to be efficient.
These ways use the first character discrimination to quickly find quotes in the string without the cost of an alternation. (The idea is to discard quickly characters that are not quotes without to test the two branches of the alternation.)
Content between quotes is described with an unrolled loop (instead of a repeated alternation) to be more efficient too:
Obviously to deal with strings that haven’t balanced quotes, you can use possessive quantifiers instead:
[^"\\]*+(?:\\.[^"\\]*)*+ or a workaround to emulate them, to prevent too much backtracking. You can choose too that a quoted part can be an opening quote until the next (non-escaped) quote or the end of the string. In this case there is no need to use possessive quantifiers, you only need to make the last quote optional.
Notice: sometimes quotes are not escaped with a backslash but by repeating the quote. In this case the content subpattern looks like this:
The patterns avoid the use of a capture group and a backreference (I mean something like
(["']).....\1) and use a simple alternation but with
["'] at the beginning, in factor.
(?s:...) is a syntactic sugar to switch on the dotall/singleline mode inside the non-capturing group. If this syntax is not supported you can easily switch this mode on for all the pattern or replace the dot with
(The way this pattern is written is totally “hand-driven” and doesn’t take account of eventual engine internal optimizations)
I would go for:
The [^”] is regex for any character except ‘“‘
The reason I use this over the non greedy many operator is that I have to keep looking that up just to make sure I get it correct.