regexp_extract

Description

Extract a specific idx group identified by a Java regex, from the specified string column. If the regex did not match, or the specified group did not match, an empty string is returned.

Usage

## S4 method for signature 'Column,character,numeric'
regexp_extract(x, pattern, idx)

regexp_extract(x, pattern, idx)

Arguments

Note

regexp_extract since 1.5.0

See Also

Other string_funcs: ascii, ascii, ascii,Column-method; base64, base64, base64,Column-method; concat_ws, concat_ws, concat_ws,character,Column-method; concat, concat, concat,Column-method; decode, decode, decode,Column,character-method; encode, encode, encode,Column,character-method; format_number, format_number, format_number,Column,numeric-method; format_string, format_string, format_string,character,Column-method; initcap, initcap, initcap,Column-method; instr, instr, instr,Column,character-method; length, length,Column-method; levenshtein, levenshtein, levenshtein,Column-method; locate, locate, locate,character,Column-method; lower, lower, lower,Column-method; lpad, lpad, lpad,Column,numeric,character-method; ltrim, ltrim, ltrim,Column-method; regexp_replace, regexp_replace, regexp_replace,Column,character,character-method; reverse, reverse, reverse,Column-method; rpad, rpad, rpad,Column,numeric,character-method; rtrim, rtrim, rtrim,Column-method; soundex, soundex, soundex,Column-method; substring_index, substring_index, substring_index,Column,character,numeric-method; translate, translate, translate,Column,character,character-method; trim, trim, trim,Column-method; unbase64, unbase64, unbase64,Column-method; upper, upper, upper,Column-method

Examples

## Not run: regexp_extract(df$c, '(\d+)-(\d+)', 1)