Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 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

 

1 Reply