Extract number from text string based on conditions

[Anonymous]

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 the next space after URGENT:
ElseIf
Description starts with "IN" Take from beginning of string to the first space
ElseIf
Description starts with "CT" Take from beginning of string to the first space
Else
"Unknown"

EndIF

[Ashish_Mathur · Accepted solution]

Hi,

Share some data and show the expected result.