I am working with a Google Sheets document in which I need to manipulate strings and extract certain parts of them. These strings have exactly the following form, to the character:
Ad name: FOO_FOOBAR_DE_CH_Zagreb+N1_970x250.zip; 970x250
I need to extract two "fields":
In Google Speadsheets, you may use a capturing group around the piece of text you need to extract from a specific context. Thus, just place
) around those pattern parts.
=REGEXEXTRACT(F15,"_([a-zA-Z]+)\+") and to get the resolution, use
_- an underscore that is just matched
([a-zA-Z]+)- Capture group 1 matching one or more ASCII letters
\+- a literal
;and 0+ whitespaces
([0-9x]+)- Capture group 1 matching one or more digits or
$- at the end of the cell contents.
In both cases, you only get the substrings captured into Group 1.
More information about capturing groups can be found here.