Parse Market Square's sales export, quotes and all, and turn it into revenue per category without letting one bad row spoil the report.
CSV fields
Split one CSV line into fields, with quoted fields, escaped quotes and strict errors.
Category report
Find columns by name, total revenue per category, and list the lines that were skipped.
Newlines inside quoted fields
Product descriptions now contain line breaks. Parse the whole file, not line by line.
Coding puzzles train one skill. Here's what else the job needs, how to practise it, and how to balance interview prep with real project work.
Model order statuses, CSV quoting and regex matching as state machines: one transition table, guards for business rules, event logs you can replay, and NFAs that track several states.