Explore a set of string manipulation functions that allow you to perform operations like concatenation, substring extraction, text replacement, and case conversion. These functions are useful for cleaning, formatting, and analyzing textual data in customer and transactional records, ensuring consistency and accuracy in your dataset.
concat(value_1, value_2, ...)
concat(first_name, " ", last_name)
.contains(string, search_string)
contains(description, "refund")
.length(string)
length(comment)
.lower(string)
lower(email)
.position(string, search_string)
position(email, "@")
.replace(string, old_string, new_string)
replace(feedback, "recieved", "received")
.substring(string, start_position, length)
substring(product_info, 4, 8)
where the code starts at the 4th character and is 8 characters long.upper(string)
upper(invoice_ref)
.FIND(search_for, text_to_search, [starting_at])
FIND("US", address)
might be used. Returns the position of US in Address column string.TRIM(text)
TRIM(customer_name)
.