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