Power QueryExercises

Module 6

Text transformations

Trim, clean, change case, split, merge, extract and replace text with exact semantics.

You'll be able to

Lessons

  1. 1.Trim, clean and capitalise textStandardise text so equal things compare equal.
  2. 2.Split columns and extract text by delimiterSplit and extract text in a way that works for values of any length.
  3. 3.Replace values exactlyReplace values without accidentally changing partial matches.
  4. 4.Combine text values and handle missing partsBuild combined text such as full names and labels without stray nulls or separators.

Take the text transformations quiz (8 questions)

Exercises