Module datafusion::functions::string::expr_fn

source ·

Functions§

  • ascii
    Returns the numeric code of the first character of the argument.
  • bit_length
    Returns the number of bits in the string
  • btrim
    Removes all characters, spaces by default, from both sides of a string
  • chr
    Converts the Unicode code point to a UTF8 character
  • concat
    Concatenates the text representations of all the arguments. NULL arguments are ignored
  • concat_ws
    Concatenates all but the first argument, with separators. The first argument is used as the separator string, and should not be NULL. Other NULL arguments are ignored.
  • ends_with
    Returns true if the string ends with the suffix, false otherwise.
  • initcap
    Converts the first letter of each word in string in uppercase and the remaining characters in lowercase
  • levenshtein
    Returns the Levenshtein distance between the two given strings
  • lower
    Converts a string to lowercase.
  • ltrim
    Removes all characters, spaces by default, from the beginning of a string
  • octet_length
    returns the number of bytes of a string
  • overlay
    replace the substring of string that starts at the start’th character and extends for count characters with new substring
  • repeat
    Repeats the string to n times
  • replace
    Replaces all occurrences of from with to in the string
  • rtrim
    Removes all characters, spaces by default, from the end of a string
  • split_part
    Splits a string based on a delimiter and picks out the desired field based on the index.
  • starts_with
    Returns true if string starts with prefix.
  • to_hex
    Converts an integer to a hexadecimal string.
  • trim
    Removes all characters, spaces by default, from both sides of a string
  • upper
    Converts a string to uppercase.
  • uuid
    returns uuid v4 as a string value