Reference
No results for 'undefined'
    Powered by Algolia

    REGEXEXTRACT

    Extracts matching substrings according to a regular expression.

    Syntax

    =REGEXEXTRACT(text, [regexString])

    Parameters

    1. text
      • Type: String
      • Description: The input text.
    2. regexString [optional]
      • Type: String
      • Description: The first part of text that matches this expression will be returned.

    Returns

    • Type: String
    • Description: Returns a single match, or a frame in case of multiple matches

    Example

    =REGEXEXTRACT("text", "ab(.*)")

    Try It Now

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.

    See Also

    Contents