SUBSTITUTE & REPLACE: Swap Text and Target the nth Occurrence
This lesson is part of the course
In this lesson
You migrate Pinewick's SKUs: switch the separator, count the parts, cut the last part after the LAST hyphen and rebrand the prefix by position.
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