Day 32 · Friday, 4 September 2026

From the archive

Intermediate

Standardize signup emails and pull out each username

LOWER folds case out of an email for de-duplication; LEFT and FIND together peel off the part before the @ without knowing how long it is.

Task:

You run marketing operations for a small online retailer. This week's newsletter signups came in through three different forms, so the emails your export gives you are in inconsistent case — the mail platform treats "Priya.Patel@GMAIL.com" and "priya.patel@gmail.com" as two different addresses, which would double-count some subscribers. Before loading the list, put a lowercase version of each email in column C for de-duplication, and each signup's username — the part before the @, in its original case — in column D for a personalized greeting.

The daily challenge is part of Pro

A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.