instr

Description

Locate the position of the first occurrence of substr column in the given string. Returns null if either of the arguments are null.

Usage

## S4 method for signature 'Column,character'
instr(y, x)

instr(y, x)

Arguments

Details

Note: The position is not zero based, but 1 based index. Returns 0 if substr could not be found in str.

Note

instr 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; 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_extract, regexp_extract, regexp_extract,Column,character,numeric-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: instr(df$c, 'b')