Module expr_fn
Source - char_length
- the number of characters in the
string - character_length
- the number of characters in the
string - find_in_set
- Returns a value in the range of 1 to N if the string
str is in the string list strlist consisting of N substrings - initcap
- converts the first letter of each word in
string in uppercase and the remaining characters in lowercase - instr
- finds the position from where the
substring matches the string - left
- returns the first
n characters in the string - length
- the number of characters in the
string - lpad
- fill up a string to the length by prepending the characters
- position
- finds the position from where the
substring matches the string - reverse
- reverses the
string - right
- returns the last
n characters in the string - rpad
- fill up a string to the length by appending the characters
- strpos
- finds the position from where the
substring matches the string - substr
- substring from the
position to the end - substr_index
- Returns the substring from str before count occurrences of the delimiter
- substring
- substring from the
position with length characters - translate
- replaces the characters in
from with the counterpart in to