func.trim
TRIM is a function that takes a character expression and returns that expression with leading and/or trailing pad characters removed
Text
func.translate
Any character in string that matches a character in the from set is replaced by the corresponding character in the to set
func.substring
The SUBSTRING() extracts a substring with a specified length starting from a location in an input string
func.strpos
The strpos() function finds the position of the first occurrence of a string inside another string
func.rtrim
The rtrim() function removes whitespace or other predefined characters from the right side of a string
func.rpad
RPAD function pads the right-side of a string with a specific set of characters (when string1 is not null).
func.replace
The function will replace part of a text string, based on the number of characters you specify, with a different text string
func.repeat
This function takes an input of Any Type and returns a list with the input repeated a specified number of times.
func.regexp_replace
This function returns a new string with the substrings, which match a regular expression pattern, replaced by a new substring
func.quote_literal
Returns the specified string as a quoted string so that it can be used as a string literal in a SQL statement
func.octet_length
The OCTET_LENGTH function returns an integer indicating the number of bytes in the input string
func.numericize
Attempts to coerce a non-numeric R object to natomic_object() or list of {natomic_object}
func.md5
MD5(Message Digest Function) evaluates data integrity. It calculates the MD5 hash of a string and returns the result in hexadecimal.
func.ltrim
LTRIM() function helps to return remove all the space characters found on the left-hand side of the string
func.lpad
LPAD function pads the left-side of a string with a specific set of characters (when string1 is not null).
func.lower
The function will return the lowercase version of the text string given.
func.length
Indicates how many arguments the function expects
func.integerize_truncate
Takes a single numeric argument x and returns a numeric vector containing the integers formed by truncating the values in x toward 0
func.integerize_round
Rounds the values in its first argument to the specified number of decimal places
func.initcap
This function converts the first letter of each word in a string to uppercase; converts any remaining characters in each word to lowercase
func.concat
The CONCAT function combines the text from multiple ranges and/or strings, but it doesn't provide delimiter or IgnoreEmpty arguments
func.chr
The chr() function returns the character that represents the specified unicode
func.char_length
The CHAR_LENGTH function returns the number of logical characters in its argument -character column, character variable, or a quoted string
func.btrim
The PostgreSQL btrim function is used to remove the longest string specified in the argument from the start and end of the given string
func.upper
This method converts all lowercase characters in a string into uppercase characters and returns it
func.bit_length
Returns the number of bits required to represent an integer in binary, excluding the sign and leading zeros
func.ascii
The ASCII function takes a single argument of any character data type and returns an integer based on the first character data
func.metric_multiply
The Multiply function can take multiple metrics as inputs and multiply the values of the metrics
func.split_part
The split_part function is used to split a given string based on a delimiter and pick out the desired field from the string
func.text_to_bigint
This function allows you to convert a string of character values into a large range integer
func.text_to_bool
Converts the input text or numeric expression to a Boolean value
func.text_to_integer
Convert text to integer
func.text_to_numeric
This function converts a character string to a numeric value
func.text_to_smallint
A 2-byte integer data type used in CREATE TABLE and ALTER TABLE statements
func.to_ascii
Convert text to ASCII from another encoding
func.to_hex
Convert number to its equivalent hexadecimal representation
Last modified December 20, 2022 at 10:05 AM EST: remove sitemap priority (56709da)