Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
The single category separated by a comma in a Star is Born was tricky, the rest were semicolons. I was probably too proud of this formula for extracting the nominee:
Solution attached. For the drop-down tool, rather than pulling the Award Category names from the Oscar Winners text file, I wanted to give myself some extra RegEx practice, so I pulled the Award Category names from the Oscars Log text file.