LEFT, RIGHT & LEN: Fixed-Width Codes
This lesson is part of the course
In this lesson
You split Pinewick's order IDs into country and order number, measure every ID with LEN and count the IDs that have the wrong length.
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