Challenge #153: And the Oscar goes to...

[rcarog]

Solution attached.

[Toons]

My solution :

Spoiler

[mot]

Solution attached.

[AndrewS]

#153

Spoiler

[JoshML]

Spoiler

[mpennington]

Enjoyed this one.  

Spoiler

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:

IIF([Dash?], REGEX_Replace([Details], '(.*)\s-\s(?:Screenplay|Written)*(?:\sby\s)*(.*)', '$2'),Null())​

[WernerE]

Spoiler

[joelmiller66]

Spoiler

[MichelleL]

Fun!

[mnmemilymnm]

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.