TRIM, CLEAN, PROPER, UPPER & LOWER: Tidy Customer Data
This lesson is part of the course
In this lesson
You clean Pinewick's newsletter sign-ups: proper names, lower-case emails, promo codes without any spaces, and a case-sensitive count of the names that were already clean.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- LEFT, RIGHT & LEN: Fixed-Width Codes Locked
- FIND vs SEARCH and MID: Extract Text Between Delimiters Locked
- SUBSTITUTE & REPLACE: Swap Text and Target the nth Occurrence Locked
- TRIM, CLEAN, PROPER, UPPER & LOWER: Tidy Customer Data Locked
- Joining Text: &, CONCAT and TEXTJOIN Locked
- TEXT and Number Formats: Labels, IDs and Leading Zeros Locked
- Splitting Full Names, Emails and Addresses Locked
- Capstone: Parse Product Codes and Chart Counts by Category Locked