Text


func.trim

TRIM is a function that takes a character expression and returns that expression with leading and/or trailing pad characters removed

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 April 06, 2022 at 10:08 AM EST: Initial Documentation Commit (371ae8f)