Module text 

Text formula functions: CONCAT, FIND, SEARCH, SUBSTITUTE, REPLACE, REPT, EXACT, T, PROPER.

Functions

fn_concat

CONCAT(text1, [text2], …) - concatenates multiple values.

fn_exact

EXACT(text1, text2) - case-sensitive comparison.

fn_find

FIND(find_text, within_text, [start_num]) - case-sensitive search.

fn_proper

PROPER(text) - capitalizes first letter of each word.

fn_replace

REPLACE(old_text, start_num, num_chars, new_text) - replaces by position.

fn_rept

REPT(text, number_times) - repeats text.

fn_search

SEARCH(find_text, within_text, [start_num]) - case-insensitive search with wildcards.

fn_substitute

SUBSTITUTE(text, old_text, new_text, [instance_num]) - replaces occurrences.

fn_t

T(value) - returns text if value is text, empty string otherwise.