Extract number from text string based on conditions

I have a case description and I want to extract a partial string based on several conditions:   Basically:   Job Name = SWITCH Description starts with 'URGENT:' Take the following string up to th...