Power QueryExercises

Text transformations quiz

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

Revise first: Trim, clean and capitalise text, Split columns and extract text by delimiter, Replace values exactly, Combine text values and handle missing parts

Question 1

1.What does this return?

Text.Trim("  North  side ")
Question 2

2.What does this return?

Text.Proper("mcDONALD")
Question 3

3.What does this return?

Text.AfterDelimiter("a.b@firm.example", "@")
Question 4

4.What does this return?

Text.PadStart("42", 5, "0")
Question 5

5.What does this return?

Text.Contains("Billing", "bill")
Question 6

6.You replace "Mail" with "M" using Replacer.ReplaceText. What happens to "Email"?

Question 7

7.Why prefer Text.BeforeDelimiter over Text.Start(…, 10) to get an email's user part?

Question 8

8.Splitting "Ana Maria Silva" by space into two named columns gives what?

0 of 8 answered. Unanswered questions count as wrong.