substring_index {SparkR}R Documentation



Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything the left of the final delimiter (counting from left) is returned. If count is negative, every to the right of the final delimiter (counting from the right) is returned. substring_index performs a case-sensitive match when searching for delim.


## S4 method for signature 'Column,character,numeric'
substring_index(x, delim, count)

substring_index(x, delim, count)



a Column.


a delimiter string.


number of occurrences of delim before the substring is returned. A positive number means counting from the left, while negative means counting from the right.


substring_index 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_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; translate, translate, translate,Column,character,character-method; trim, trim, trim,Column-method; unbase64, unbase64, unbase64,Column-method; upper, upper, upper,Column-method


## Not run: 
##D substring_index(df$c, '.', 2)
##D substring_index(df$c, '.', -1)
## End(Not run)

[Package SparkR version 2.1.0 Index]