Lesson 7.1 · Pro

Clean and join text

Change case, trim spaces, replace characters, and glue columns together safely.

In this lesson

  1. Change case and trim spaces
  2. Replace characters
  3. Glue text together: || and concat
  4. Build a key from several columns