Cleaning messy text
Fix text typed in by hand with trim, lower, replace, substr and instr, so one team stops showing up as four different teams.
- The skill
- Clean up text that people typed in by hand, and cut useful parts out of it, before you group or count.
- You make
- A tidy squad list for a five-a-side football league whose sign-up form let everyone type whatever they liked.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 34 Dates and times in SQL. Free to try: SQL Foundations and the playground.
Passed
You can now
Step 1 of 8
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite