Cleaning String Functions
Text functions are functions that manipulate text-based data, such as TRIM or CLEAN.
Common String Functions
TRIM- Removes leading and trailing spaces and extra spaces between words
CLEAN- Removes all non-printable characters
LEFT- Returns a number of characters from the left side of the field
RIGHT- Returns a number of characters from the right side of the field
MID- Returns a number of characters from the middle of the field
UPPER- Converts the field to uppercase
LOWER- Converts the field to lowercase
PROPER- Capitalizes the first letter of each word
LEN- Produces a number that is the count of the characters and spaces in that field