SJS.REGEXEXTRACT

Syntax Argument Description text (Required) The text you are searching within. Wildcard characters are not allowed. If the text is an empty string, returns empty text.you can input a string like “text“, or a cell reference like “C4”, or a cell range reference like “C4: D4“ (work in dynamic array) regular_expression (Required) The first part of text that matches this expression will be returned.You can input a string like “[0-9]+“,or a cell reference like “C4“. modifiers The modifiers to define the pattern.You can input a string like “gi“, or a cell reference like “C4“. Modifiers Modifier Name Description g global Retain the index of the last match, allowing subsequent searches to start from the end of the previous match.Without the global flag, subsequent searches will return the same match. i ignore case Makes the whole expression case-insensitive.For example, /aBc/i would match AbC. m multiline When the multiline flag is enabled, beginning and end anchors (^ and \$) will match the start and end of a line, instead of the start and end of the whole string.Note that patterns such as /^[\s\S]+$/m may return matches that span multiple lines because the anchors will match the start/end of any line. u unicode When the unicode flag is enabled, you can use extended unicode escapes in the form \x{FFFFF}.It also makes other escapes stricter, causing unrecognized escapes (ex. \j) to throw an error. y sticky The expression will only match from its lastIndex position and ignores the global (g) flag if set. Because each search in RegExr is discrete, this flag has no further impact on the displayed results. s dotAll Dot (.) will match any character, including newline. Please make sure your browser supports the modifiers you use. The modifier “y“ is not supported in SJS because sticky will lead to inconsistent calculation results.If modifier “y“ is set, it will be ignored in the calculation. Dynamic Array If allowDynamicArray is set to false, SJS.REGEXEXTRACT can still work. But for some cases, you may need to set allowDynamicArray to true to get the best result. In the below example, you will get "Luve" as the result when the allowDynamicArray flag is false, and ["Luve", "rose"] as the result when the flag is true. Samples