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)

Details

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

See Also

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

Examples

## Not run: instr(df$c, 'b')