Lesson 8 of 20

Clean and assemble text

Normalize labels with TRIM, UPPER, LOWER, LENGTH and concatenation.

27 minDiscovery access

By the end of this lesson

  • Clean stray spaces
  • Uniform case
  • Build a label without losing values NULL

Free Discovery access

Create your space to open this lesson.

Clean and assemble text is one of 8 lessons and 15 free exercises linked to an account. No card is required.

  • Resume progress from your account
  • Exercises with expected results and explanations
  • Guided Sales Analysis project
Free permanent access.