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