Text Functions

[henneberger]

Text

• translate: Replaces characters in a string based on a mapping.
• format: Returns a formatted string using placeholders. (move)
• json_extract_path_text: Extracts JSON object field text based on a specified path.
• initcap_each_word: Capitalizes the first letter of each word in a string.
• remove_accents: Removes diacritical marks (accents) from a string.
• regex_split_to_array: Splits a string into an array using a regular expression delimiter.
• levenshtein: Computes the Levenshtein distance between two strings.
• repeat: Repeats a string a specified number of times.
• regexp_replace: Replaces matching groups of regular expressions
• soundex: Returns a phonetic representation of a string.
• diff_text: Compares two strings and returns their differences.
• quote_literal: Escapes a string for use as a SQL literal.
• decode_url: Decodes an encoded URL string.
• encode_url: Encodes a string for safe inclusion in a URL.
• substring_index: Returns the substring before the specified number of occurrences of a delimiter.