Assistance with Variable Creation

Content

I am trying to write a variable to display a particular portion of a subject line of a correspondence in a report cell/column

The full subject line is:

Req # - Phone Screen - Candidate Name - Position Title

Req # - Interview Request - Candidate Name - Position Title

Req # - Schedule Test - Candidate Name - Position Title

What I would like displayed in the column instead is "Phone Screen", "Interview Request"; "Schedule Test"

How would I create a variable to do this?

Thanks

Amy DiamondSr. Business Analyst I Global Talent Management I Manulife Financial