AS_STRING function
The as_string function converts various data types into a string format. This function is particularly useful when you need to ensure that data is in a consistent, readable format for display, concatenation, or further text-based operations.
REGEX_EXTRACT function
The regex_extract function takes an input string and a regular expression (regex) pattern and extracts all the substrings that match the pattern. It returns a list of these matching substrings. This function is useful for parsing text and extracting specific data based on patterns, such as extracting email addresses, phone numbers, dates, or any other patterns from a given text.